Insights Hub How do I display data in Business Intelligence with my time zone instead of UTC?

When you are uploading Timeseries data to Insights Hub and viewing the data in Business Intelligence, you may want to see it with your time zone such as CEST.

Currently there is no configuration option to show data in the specific time zone.

Business Intelligence is using world-leading data annalistic platform, Tableau. As of July 2021, the ability to specify the time zone for the display of data is not provided.

You can use Calculated Field to adjust the time which is assigned to your data.

Here are the steps to adjust the time.

1. Original data shows the last timestamp of the data is 1 o'clock of July 2nd in UTC.

firsttime is used for Columns axis.

Create "Calculated Field" from the menu dropdown list.

Type the fired name as you like and code with DATEADD function.

In this case, 2 hours will be added for [firsttime] items to adjust to CEST (UTC +2).

Use firsttime_shifted which you created instead of firsttime.

Teen  you will see that the last time in the chart is 3 o'clock of July 2nd and all the data has shifted back 2 hours.

In this way, you can easily adjust the time zone of displaying data.

Notes

Tableau provides many practical functions such as date control.

Please refer to their web site for details.

Functions in Tableau