I have a report that displays records created per hour, for the previous 24 hours. I would like to sort these hours from newest to oldest. The issue is that if the current time is 1630 (red line), all records in the report with a created hour greater than 1630 are from the previous day. And if I click to view records created in the 1600 hour it includes records from today and yesterday. Is there a way to do this?
Hi @Community Alums ,
You can't sort the graph from newest to oldest, as both yesterday and today have a timestamp for e.g. 1400, and yesterday have a timestamp at 2200. If you would like to enhance the visualization, you can utilize below conditions for the main graph:
Afterwards add another dataset in another color where conditions is almost the same except, created should be on today.
If my answer has helped with your question, please give a thumb up and mark as accepted solution.
best regards
Anders
Hi @Community Alums ,
You can't sort the graph from newest to oldest, as both yesterday and today have a timestamp for e.g. 1400, and yesterday have a timestamp at 2200. If you would like to enhance the visualization, you can utilize below conditions for the main graph:
Afterwards add another dataset in another color where conditions is almost the same except, created should be on today.
If my answer has helped with your question, please give a thumb up and mark as accepted solution.
best regards
Anders
Thank you. Your suggestion looks much better.
