I have a requirement from customer stating that he wants a report for a dashboard:
I went ahead and did the following steps to create the report:
Please let me know how could i get the report on a daily basics from 4 am to 6 am for the corresponding day.
Thanks in advance.
Can you change the timeframe on your dashboard to "Last X" and specify "2 hours" shift by "4 hours". That should execute the report at 10AM and use the timeframe from 4 to 6AM (shift by 4 hours = 6AM and then last 2 hours from that point on).
Please give this a try. In the moment - when you specify a certain timeframe you also specify the data. Thats why the report always comes up with Nov 5th which is probably the day in your timeframe definition