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
20/01/2020,program1,8000,5444
20/01/2020,program2,8000,1224
21/01/2020,program1,1000,1123
21/01/2020,program2,1000,1122
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.
VolumeProgram1
VolumeProgram2
DurationProgram1
DurationProgram2
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 :
Volume
DurationProgram1
DurationProgram2
Is there a way to merge the data ?
Thanks
... View more