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

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

    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

      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

        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.