cancel
Showing results for 
Search instead for 
Did you mean: 

How do you handle timezone conversions on dashboards?

barrytallis
7 - Data Storage
7 - Data Storage

We store our dates in UTC format and want the ability for dashboard viewers to view the date data in their timezone, or in a timezone they select.  Has anyone figured out a way to do this?  We have a LOT of date data in our data model.

1 ACCEPTED SOLUTION

dougwalters
7 - Data Storage
7 - Data Storage

Here's a link to some Sisense documentation on time zones...you would create a custom date table (or I suppose you could add custom columns to an existing table) and then assign specific users access to only certain timezones through data security?

https://support.sisense.com/kb/en/article/enabling-timezone-by-user

View solution in original post

2 REPLIES 2

dougwalters
7 - Data Storage
7 - Data Storage

Here's a link to some Sisense documentation on time zones...you would create a custom date table (or I suppose you could add custom columns to an existing table) and then assign specific users access to only certain timezones through data security?

https://support.sisense.com/kb/en/article/enabling-timezone-by-user

View solution in original post

James
7 - Data Storage
7 - Data Storage

Hi Barry,

RAPID BI (https://www.rapidbi.com.au) has developed a World Time by Elasticube add-in that deals with this issue and allows relative dates on the front end. It not only solves the UTC problem but can be configured per Elasticube.

It has been in production for a client for over a year now, but we have not yet packaged it for the marketplace. Reach out to us if you are interested.

Cheers,

James.