Change Time Field Granularity in Tables

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. The selected granularity is applied to the time field.
5. Save the dashboard and visual.

Change Metric Aggregation in Tables

You can change the aggregation of metrics in a table after the table has been grouped. Aggregation settings can be changed on the Table Settings sidebar and using the table context menu.

Note: you cannot change the aggregation setting for a metric that is used in grouping the table. When a metric is used to group a table, the sum of that field is used for grouping.