barrytallis
10-25-2021Data Storage
How do you handle timezone conversions on dashboards?
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.
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