topic Re: Group by date in a visual in App Development

Group by date in a visual

BenjaminCoe1440 — Fri, 25 Nov 2022 15:27:20 GMT

I have a chart which monitors meter readings (below; blue). There are numerous readings per date (spread out over 48 readings; half-hourly) and the dataset that I am using has a row for each reading.

Is it possible group in the chart by day without having to create a separate table with one row per date?

Re: Group by date in a visual

MarcoWedel — Fri, 25 Nov 2022 21:46:54 GMT

Do you mean to aggregate (in this case sum) all 48 half-hour readings to get one single value per day?

In this case I think you just have to replace your dimension with the ReportDate you already seem to have
(although your dimension axis is already labeled as "ReportDate", yet it seems to use timestamps rather than dates?!?)