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
8 - Cloud Apps
8 - Cloud Apps

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

5 REPLIES 5

dougwalters
8 - Cloud Apps
8 - Cloud Apps

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

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.

chadwick526
Sisense Team Member
Sisense Team Member

Hi James can you direct to the link for that add-on? I don't see it advertised here: https://www.sisense.com/marketplace/

Chad Solomon
Senior Technical Account Manager

Hi Chad,

We actually have a lot of add-ins not yet on the Marketplace, but have been in production for a long time with our members (RAPID BI Members have access to our add-ins rather than having to purchase separately). We are working on the marketing materials together for these add-ins and they will be on the Marketplace soon.

If you can please fill in the contact form on our website (https://www.rapidbi.com.au/contact-us.php) we can demonstrate this and our other add-ins for you and email you some information.

Cheers,

James Kruss

Benji_PaldiTeam
10 - ETL
10 - ETL

Hi @barrytallis 
I'm Benji from Paldi Solutions, nice to e-meet you (:

Dealing with multiple time zones is a really common use case, as you can see in the comments you have few available options to choose.

One of them is Paldi's TimeZone Adjustment

The advantage of using this plugin is that it intercepts all the queries "behind the scenes" and there is no need for Elasticube changes or sophisticated front-end scripts to be applied so users will see the data in their own time zone.


Feel free to reach out of you have further questions, we're always happy to help (: 
Paldi Solutions - Number #1 Sisense Plugins Developer