Menu
Amazon QuickSight
User Guide

Changing Date Field Granularity

You can change the granularity for a date field on a visual to determine the intervals for which item values are shown. You can set the date field granularity to one of the following values:

  • Year (this is the default).

  • Month

  • Week

  • Day

  • Hour. This is only supported when the date data includes time information.

Changing Date Field Granularity by Using an On-Visual Editor

Use the following procedure to change date field granularity by using an on-visual editor.

  1. On the visual, choose the field well for the date field whose granularity you want to change.

  2. On the field well menu, choose Aggregate, then choose the time interval you want to apply, as shown following:

Changing Date Field Granularity by Using a Field Well

Use the following procedure to change date field granularity by using a field well.

  1. Expand the Field wells pane by choosing the expand icon.

  2. Choose the field well containing the date field.

  3. On the field well menu, choose Aggregate, then choose the date granularity you want to use.