Customer is looking to convert one of DateTime fields into any specified Timezone by supplying TimezoneID (eg: Asia/Jerusalem, America/Los_Angeles) not by adding any Offset. Idea is it should support Daylight saving out of box so meaning date during DST so it would change accordingly.
1 Like
Hello @hanishg, welcome to the Quick Sight community!
This functionality is not available out of the box. There unfortunately isn’t a plug and play solution to resolve this. The options that you have would be to publish individual dashboards with the various Time zones applied:
Or, create multiple datetime fields in your dataset for each of the Time zones required, and set up some filtering capabilities in the dashboard. If you created a parameter with a custom list of options, you could utilize that to return the correct datetime field.
The calculation would look something like this:
ifelse(${TimezoneParameter} = 'America/Los Angeles', {America/Los Angeles Datetime},
${TimezoneParameter} = ' Asia/Jerusalem', {Asia/Jerusalem Datetime},
{Default Datetime}
)
This would allow the user to change between the various Time zones depending on their use case. Let me know if this helps!
1 Like
thanks a lot for the guidance.
1 Like