Bucketization using Fiscal Calendars

With UserDefinedBucketization, a TLV can also be bucketized by the FiscalCalendar for an enterprise. This allows the user to bucketize data measure values along the FiscalCalendar boundaries.

The following FISCAL bucketization types are available:


  1. FISCAL_WEEK

  2. FISCAL_MONTH

  3. FISCAL_QUARTER

  4. FISCAL_YEAR

Here is a sample UserDefinedBucketization with Fiscal bucketization types:

<UserDefinedBucketization>
<Bucketization defaultBuckets="30" maxBuckets="60">DAILY</Bucketization>
<Bucketization defaultBuckets="4" maxBuckets="8" default="true">WEEKLY</Bucketization>
<Bucketization defaultBuckets="4" maxBuckets="8">MONTHLY</Bucketization>
<Bucketization defaultBuckets="4" maxBuckets="8">FISCAL_WEEK</Bucketization>
<Bucketization defaultBuckets="3" maxBuckets="9">FISCAL_MONTH</Bucketization>
<Bucketization defaultBuckets="4" maxBuckets="8">FISCAL_QUARTER</Bucketization>
<Bucketization defaultBuckets="3" maxBuckets="9">FISCAL_YEAR</Bucketization>
</UserDefinedBucketization>

And the Timeline field for the above configuration:

images/download/attachments/144835648/timeline_control_fiscal-version-1-modificationdate-1645047424000-api-v2.png

FISCAL bucketization types are only included in a Bucketization list if a FiscalCalendar has been loaded for the governing enterprise. (This defaults to the currently logged in user's role's enterprise.)

Below is a sample TLV with bucketization FISCAL_WEEK and DateRange from 9/26/16 to 10/16/16:

images/download/attachments/144835648/fiscal_week_tlv-version-1-modificationdate-1645047440000-api-v2.png

Fiscal Relative Dates

For TLVs with FISCAL type bucketization, the User can also provide relative fiscal dates in the TLV Date Range/Start Date filter:
images/download/attachments/144835648/fiscal_relative_links-version-1-modificationdate-1645047450000-api-v2.png