Forum Discussion
Include time stamp on dataset view in service
How would I include a time stamp visual that originates from a dataset that is on an autorefresh schedule q2 hours? The goal is to display the time the data set was last refreshed. Thank you
Yeah, that's because of the time zone offset. Apparently the time zone of the service is +5 hours ahead or -7 hours from your time zone. You can fix that by adding or subtracting hours.
Measure 27 = NOW() + .0416666666667 * (1)
Just adjust the + sign and the 1 as needed.
4 Replies
- Greg_Deckler
Community Champion
Include a column in one of your tables that refreshes of TODAY() or NOW(). This will be updated upon refresh.
- AnonymousNot applicable
Thanks. Did that and used NOW(). Looks as expected in desk top, example 12:25 local time which matched, but service is displaying time as 5:18
- Greg_Deckler
Community Champion
Yeah, that's because of the time zone offset. Apparently the time zone of the service is +5 hours ahead or -7 hours from your time zone. You can fix that by adding or subtracting hours.
Measure 27 = NOW() + .0416666666667 * (1)
Just adjust the + sign and the 1 as needed.