I want to set up a custom report showing charts for multiple targets (hosts), separate chart for each host. The report element is based on a sql which would look like:
where -- metric, metric_column ...
The output of this query is the list of daily averages for each target name within a given period. The report I get shows one chart with graph lines representing each target(host). Having many hosts makes this chart unreadable.
I want to have one chart per host with its own graph.
One way is to define a separate report element for each target and hardcode target name in the sql, so if I have 50 targets, I will have 50 elements and 50 versions of the same sql.
I want to be able to do this with one element and one sql.
Is this possible?
The reporting framework does not provide a way to generate multiple charts from one query. However you might consider a variation on your 50 query option and report on a set of hosts per chart - maybe grouping alphabetically - or by whatever criterion makes sense for your site. Chart 1 shows hosts starting with A-F, Chart 2 shows hosts starting wiht G-L, etc.