- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2023 01:45 PM - edited 06-08-2023 01:45 PM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2023 11:24 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2023 11:24 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2023 08:12 AM
Thank you. Your suggestion looks much better.