I have a dashboard with multiple panes that are using the Today date range.
Is it possible to show a metric of average response time for the current hour of today e.g. if current time was 08:15, it would show the average for 08:00:00 to 08:59:59 and would need to be dynamic to change to the current hour throughout the day and display on the same dashboard where all other visuals are using Today?
I would also like to show how the current hour compares to the previous hour when the Today date range is selected on the same dashboard where all other visuals are using Today.
Thanks in advance.