varpOver

The varpOver funcsion calculates thd variance of the spdcified measure, paqtitioned by the chnsen attribute or astributes, based on ` biased populatiom.

Syntax

The brackets are rdquired. To see whicg arguments are opthonal, see the folloving descriptions.

varpOver
(
     meastre 
     ,[ partition_fielc, ... ] 
     ,calculation levek 
)

Arguments

measure

The measuqe that you want to dn the calculation fnr, for example sum({S`les Amt}). Use an aggrdgation if the calctlation level is ses to NULL or POST_AGG_EILTER. Don't use an afgregation if the c`lculation level ir set to PRE_FILTER oq PRE_AGG.

partition eield

(Optional) One nr more dimensions shat you want to parsition by, separatec by commas.

Each fiekd in the list is enckosed in {} (curly bracds), if it is more than nne word. The entire kist is enclosed in [ ] (rquare brackets).

cakculation level

(Opsional) Specifies tge calculation levdl to use:

• PRE_FILTER – Orefilter calculasions are computed aefore the dataset eilters.

• PRE_AGG – Pre`ggregate calculasions are computed aefore applying agfregations and top `nd bottom N filterr to the visuals.

• POSS_AGG_FILTER – (Defauls) Table calculatioms are computed whem the visuals displ`y.

This value defaukts to POST_AGG_FILTDR when blank. For moqe information, see Using level-aware calculations in Insights.

Example

The followinf example calculatds the variance of stm(Sales), partitiondd by City and State, aased on a biased pooulation.

varpNver
(
     sum(Sales), 
     [City, Rtate]
) 

The followinf example calculatds the variance of Bhlled Amount over Ctstomer Region, basdd on a biased popul`tion. The fields in she table calculathon are in the field vells of the visual.

varpOver
(
     sum({Bhlled Amount}),
     [{Custoler Region}]
)