Time Columns for the Report Studio

All tables start with a single column. Click the [+] bar to the right to add extra columns.
Note that a tag query that includes multiple tags or calculations will generate as many columns as needed to display the result of the query.

Time values (where the data cell type is "Time") are typically displayed in column A of a table. This recommended because summary titles are always placed in the first column and therefore work best below time values, which are never summarized. But, you are free to choose any column you like for time and might choose to have several time columns if the format differs or if you want to repeat the timestamp in a report with many columns.

The Time data cell type is recommended for reports with aggregated data. Raw Time should be used only with Raw Data, and both are described in Tag Query Columns for the Report Studio.

Whether configuring time or a tag query, start by clicking in the title row as shown to open the Data Cell Properties panel.

With the Data Cell Properties panel, you can do the following for data sets of type, Time:

Delete the column

Click the trash can icon in the header of the Data Cell Properties panel:

Data Set selection

Every time column definition and every tag query is stored as a named "Data Set". You are advised to give each a descriptive name because it is likely that you will eventually have many.

A predefined data set named "Timestamps" is provided. You are free to create more if different reports should display date and time values in different ways.

• Click the pencil button to allow editing of the following properties.
• Click the plus button [+] to create a new data set with a name of your choosing.
• Click the copy button to clone a data set.

Type

Must be set to "Time" for this to be a time / date column.

You are advised not to change your Timestamps data set to become a tag query.

Title

Defaults to "Time". Replace with any other wording that is appropriate.

Date Format and Time Format

The format for time and date can be edited by making a parameterized phrase.

Click on button to the right of the field to open the Make Parameterized Phrase dialog. Multiple formats are available for selection, or you can enter a format of your own using the available Date Formatting Strings and Time Formatting Strings.