Hi all,
This will likely seem like a very simple query to the community but I'm looking to have a simple table with 3 columns reading. Date, Totalised daily & totalised accumulative.
I already have the data points mapped from the controller for 2x different totalisers and I can make a simple table with the max value no problem.
My question is how do I make the report populate every row with a date range and pull the data from that specific date.
e.g
|DATE | Totalised Daily | Totalised Accumulative|
|12/2/25 | 7m3 | 42m3|
|11/2/25 | 7m3 | 35m3|
|10/2/25 | 7m3 | 28m3|
|9/2/25 | 7m3 | 21m3|
|8/2/25 | 7m3 | 14m3|
|7/2/25 | 7m3 | 7m3|