Currently we have the timezone conversion set up on database side, but if the user wants to change the timezone, then this will restart the pain stacking data import. One can solve it robustly by adding timezone difference with the DateAdd function, but coding in the daylight savings time would quickly turn custom expressions into spaghetti code.
Would be great if there is a timezone conversion function in Spotfire.
Reuired by our company as well. Requirement list:
Dashboards should display time according to the timezone settings of the OS/Browser by default
Users should be able to override the default setting
Users shall be able to set their time zone in their profile.
Dashboards should indicate what timezone is being used