There are multiple programs running every day and I want to visualise the volume and duration of each program by day.
The data looks like this :
_time, programtype, volume, daily
If i use a timechart, (e.g. | timechart span=1d values(volume) sum(duration) by programtype to display the data, I would get 4 graphs being shown.
What i want to show is, 3 graphs with the volume being generic.
*All programs will always have the same volume on the day.
How would the query look like if i want to show :
Is there a way to merge the data ?
... View more