Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
BenjaminCoe1440
Contributor III
Contributor III

Group by date in a visual

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?

 

BenjaminCoe1440_1-1669389649000.png

 

 

 

BenjaminCoe1440_0-1669389500859.png

 

Labels (2)
1 Reply
MarcoWedel

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?!?)