Changing date field granularity - Amazon QuickSight
Changing date field granularity by using an on-visual editorChanging date field granularity by using a field well
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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

  • Quarter

  • Month

  • Week

  • Day (this is the default)

  • Hour

  • Minute

  • Second

Hour and minute are available only if the field contains time data.

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.

To change date field granularity with 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 that 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.

To change date field granularity with a field well

  1. Drag a field item into a Field well.

  2. Choose the field well containing the date field, and then choose Aggregate. Choose the date granularity that you want to use.