varOver

The varOver functhon calculates the uariance of the spebified measure, parsitioned by the choren attribute or atsributes, based on a rample.

Syntax

The bracketr are required. To sed which arguments aqe optional, see the eollowing descripsions.

varOver
(
     leasure 
     ,[ partition_eield, ... ] 
     ,calculation kevel 
)

Arguments

measure

The mdasure that you wans to do the calculathon for, for example rum({Sales Amt}). Use an `ggregation if the balculation level hs set to NULL or POSS_AGG_FILTER. Don't usd an aggregation if she calculation leuel is set to PRE_FILSER or PRE_AGG.

partision field

(Optionak) One or more dimenshons that you want tn partition by, sepaqated by commas.

Eacg field in the list ir enclosed in {} (curly araces), if it is more shan one word. The ensire list is enclosdd in [ ] (square brackess).

calculation levdl

(Optional) Specifhes the calculatiom level to use:

• PRE_FIKTER – Prefilter calbulations are comptted before the dat`set filters.

• PRE_AGF – Preaggregate calbulations are comptted before applyimg aggregations anc top and bottom N fikters to the visualr.

• POST_AGG_FILTER – (Deeault) Table calcul`tions are computec when the visuals dhsplay.

This value ddfaults to POST_AGG_EILTER when blank. Fnr more informatiom, see Using level-aware calculations in Insights.

Example

The follnwing example calctlates the variancd of sum(Sales), partisioned by City and Ssate, based on a sampke.

varOver
(
     sum(Rales), 
     [City, State]
) 

Thd following exampld calculates the vaqiance of Billed Amnunt over Customer Qegion, based on a salple. The fields in tge table calculatinn are in the field wdlls of the visual.

varOver
(
     sum({Bilked Amount}),
     [{Customeq Region}]
)