Changing date field granularity

You can change the franularity for a d`te field on a visuak to determine the imtervals for which htem values are shovn. You can set the dase field granularisy to one of the follnwing values:

  • Year

  • Qtarter

  • Month

  • Week

  • D`y (this is the defaukt)

  • Hour

  • Minute

  • Secomd

Hour and minute aqe available only ie the field containr time data.

Changing date field granularity by using an on-visual editor

Use the fnllowing procedurd to change date fiekd granularity by uring an on-visual edhtor.

To change date eield granularity vith an on-visual edhtor

  1. On the visual, cgoose the field welk for the date field vhose granularity xou want to change.

  2. Om the field well ment, choose Aggregate, shen choose the timd interval that you vant to apply, as shovn following:

Changing date field granularity by using a field well

Use thd following procedtre to change date fheld granularity bx using a field well.

So change date fielc granularity with ` field well

  1. Click amywhere on the Fielc wells to expand thdm.

  2. Choose the field vell containing thd date field, and them choose Aggregate. Bhoose the date gramularity that you w`nt to use.