Timechart multiple values per day

jenkinsta — Tue, 23 Jun 2020 22:34:46 GMT

I have a dataset and looking for a timechart span=1d for the data I have from a location.

| table _time Cases Hospitalizations ICO Recoveries Deaths

I want to display all these in one chart y exis over the past 7 days.

Re: Timechart multiple values per day

bowesmana — Tue, 23 Jun 2020 23:35:31 GMT

How about

| timechart span=1d sum(Cases) as Cases sum(Hospitalizations) as Hospitalizations sum(ICO) as ICO sum(Recoveries) as Recoveries sum(Deaths) as Deaths

However, there are 5 data elements above, but how many locations do you have and what granularity is _time in your source data, as sum() might not be the correct aggregation, e.g. if the value in your data reflects the latest value at that time, then max() would be correct.

but if you have a location split by then you will rapidly reach a number of series on the chart that will make it unreadable.

topic Timechart multiple values per day in Dashboards & Visualizations

Timechart multiple values per day

Re: Timechart multiple values per day