Runtime calculations

[sagmukhe]

@damien - Did you get a chance to look at the below blog post? That may give you some cue on what you are trying to achieve.

Time Zone Adjustments

Most databases (including SPICE) store timestamps in UTC time. If you want to be able to dynamically adjust the time zone of the data displayed in your visuals for different users, we can do this using parameters and calculated fields. This technique will work both for if you want to allow Readers to change the time zone themselves (using a Control), or if you want to specify the time zone programmatically via the URL or via the JS SDK (for instance if you are embedding a dashboard in your appli…

Hope this helps!