Export fields of Duration type

Owned by Kateryna Bukhtiiarova (Unlicensed)
Last updated: Nov 13, 2023 by Anna Odrynska

Starting from Tableau Connector version 1.0.17 new option “Duration in seconds” was added as a setting for data source.

The option appears only when added table contains at least one field of Duration type, unchecked by default:

Also, the option appears automatically for data sources created from Report or from Database View, only if they contain Duration type fields. Below is an example of a data source created from the report:

In case, the added table does not contain Duration type fields, but one or more Referenced fields of this type are added - an option will appear too:

What data format to choose for export

  1. By default, when Duration fields are added and no “Duration in seconds” or “Use display value” are turn on, data will be exported in Edm.Duration format:

  2. When “Duration in seconds” is turned, data will be exported in Decimal format (seconds):

  1. When “Use display value” is turned on, data will be exported in Edm.String:

NOTE: please take into account that String format for Display value can be also seen in the backend part:

Restriction

It is impossible to apply both “Duration in seconds” and “Use display value” at once. They are mutually exclusive options. It means, that in case if “Duration in seconds” is turned on “Use display value” is turned off: