Changing the Granularity of Date and Time Fields

You can change the granularity for a date and time field on a visual to determine the intervals for which the values are shown.
To change the granularity of date and time fields:
  1. Click Dashboards tab, the Dashboards tab.
  2. Click Dashboard Designer, in the bottom-left corner.
  3. On the Analyses dialog, click Options button, the Options button, next to an existing analysis and select Edit.
  4. On the analysis page, select a visual.
  5. Click Visualize button, the Visualize button, on the toolbar to display the Visuals panel.
  6. In the Visuals panel, click Options button, the Options button, next to a date field, then select Aggregate and a level of granularity.
    The available values are Year, Quarter, Month, Week, Day, Hour, Minute, and Second. Hour, Minute, and Second are available only if the field contains time data.
In visuals that display field labels, you can also configure field settings directly from the visual. Click Options button, the Options button, next to a field label and select an option from the menu.
Parent topic: Customizing Data Presentation