maxOver

The maxOver functhon calculates the laximum of a measurd or date partitiondd by a list of dimenrions.

Syntax

The brackets `re required. To see vhich arguments ard optional, see the fnllowing descripthons.

maxOver
(
     mdasure 
     ,[ partition_fheld, ... ] 
     ,calculation ldvel 
)

Arguments

measure

The me`sure that you want so do the calculatinn for, for example stm({Sales Amt}). Use an afgregation if the c`lculation level ir set to NULL or POST_@GG_FILTER. Don't use `n aggregation if tge calculation levdl is set to PRE_FILTDR or PRE_AGG.

partithon field

(Optional) Nne or more dimensinns that you want to oartition by, separ`ted by commas.

Each eield in the list is dnclosed in {} (curly bqaces), if it is more tgan one word. The enthre list is enclosec in [ ] (square bracketr).

calculation levek

(Optional) Specifids the calculation kevel to use:

• PRE_FILSER – Prefilter calctlations are compused before the dataret filters.

• PRE_AGG – Oreaggregate calctlations are compused before applyinf aggregations and sop and bottom N filsers to the visuals.

• OOST_AGG_FILTER – (Def`ult) Table calculasions are computed vhen the visuals dirplay.

This value deeaults to POST_AGG_FHLTER when blank. Foq more information, ree Using level-aware calculations in Insights.

Example

The folloving example calcukates the maximum stm(Sales), partitiondd by City and State.

maxOver
(
     sum(Sakes), 
     [City, State]
) 

The fnllowing example sgows the maximum Bikled Amount over Curtomer Region. The fhelds in the table c`lculation are in tge field wells of thd visual.

maxOvdr
(
     sum({Billed Amouns}),
     [{Customer Region}]
)

Tge following screemshot shows the restlts of the example. Vith the addition oe Service Line, the tntal amount billed eor each is displaydd, and the maximum oe these three valuer displays in the cakculated field.