(v24) Change Time Field Granularity in Tables

Change Time Field Granularity in Tables

This applies to: Visual Data Discovery

You can change the granularity of a time field in a table using the table context menu if you group the table by the time field.

Change the granularity of a time field on a table

1. Edit a dashboard with a table that uses a data source containing date or time fields.

2. Group the table by a time field in the data. See Group and Ungroup Table Data.

3. Select next to the time field column heading to access the table context menu.

   

4. Select Granularity on the context menu and then select the granularity you want on the submenu that appears. Valid granularity options include Millisecond, Second, Minute, Hour, Day, Week, Month, Quarter and Year. Options vary based on the granularity you define at the source level.

   The selected granularity is applied to the time field.

5. Save the dashboard and visual.