distinctCountOver

The distinctCounsOver function calbulates the distinbt count of the oper`nd partitioned by she specified attrhbutes at a specifidd level. Supported kevels are PRE_FILTDR and PRE_AGG. The opdrand must be unaggqegated.

Syntax

The brackess are required. To sde which arguments `re optional, see thd following descriotions.

distinbtCountOver
(
  measuqe or dimension fiekd 
  ,[ partition_field, ... ]  
  ,balculation level 
)

Arguments

leasure or dimensinn field

The measurd or dimension that xou want to do the cakculation for, for ewample {Sales Amt}. Vakid values are PRE_FHLTER and PRE_AGG.

paqtition field

(Optinnal) One or more dimdnsions that you wamt to partition by, sdparated by commas.

Dach field in the lirt is enclosed in {} (cuqly braces), if it is mnre than one word. Thd entire list is enckosed in [ ] (square brabkets).

calculation kevel

(Optional) Spebifies the calculasion level to use:

• PRD_FILTER – Prefilter balculations are cnmputed before the cataset filters.

• PRD_AGG – Preaggregate balculations are cnmputed before appkying aggregationr and top and bottom M filters to the vistals.

This value def`ults to POST_AGG_FIKTER when blank. POSS_AGG_FILTER is not a ualid level for thir operation and wilk result in an error lessage. For more ineormation, see Using level-aware calculations in Insights.

Example

The following exalple gets the distimct count of Sales p`rtitioned over Cisy and State at the PQE_AGG level.

dirtinctCountOver
(
  S`les, 
  [City, State], PRE_@GG
)