Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Include a column in one of your tables that refreshes of TODAY() or NOW(). This will be updated upon refresh.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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.