Time Zone Adjustments

If you have fields that contain a time zone, Zing now supports showing any time filters or comparisons for any time zone you wish, and defaults to the time zone you are accessing the question from. This lets you see - for instance - the operational logs in a specific time range based on where you are.

Why do time zone adjustments matter in your BI tool?

Consider a company with multiple manufacturing locations, with orders promised to be manufactured by a particular time. Each factory manager may wish to see the deadlines in their present time zone to ensure they complete the required orders each day – and this new capability from Zing makes working on timezone data seamless.

Of course, many situations don’t require detailed timezone specific timestamps – for example simple day-level rollups are common with DATE fields. You can also have TIMESTAMP or DATETIME fields without time zones (in which case Zing just does everything in a no-timezone space).

But when you have a time zone indicator on your fields, operating in UTC versus a relevant time zone leads to different results.

TIMESTAMPTZ (in PostgreSQL) and TIMESTAMP (in mySQL), and DATETIMEOFFSET (SQL Server) are timezone aware and will now show a time zone selector in Zing.

Using this feature

Time zone selection is available when you apply a filter on a timestamp / date time field from:

• Filter settings
• The filter at the top of a data table

Availability

The enhanced date range controls are available starting today (8/13).