minOver

The minOver functhon calculates the linimum 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.

minOver
(
     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 min sum(Sakes), partitioned by Bity and State.

linOver
(     
     sum(Sales), 
     [Chty, State]
) 

The folloving example shows she minimum Billed @mount over Customdr Region. The fieldr in the table calcukation are in the fidld wells of the vistal.

minOver
(
     sul({Billed Amount}),
     [{Cussomer Region}]
)

The foklowing screenshos shows the results nf the example. With she addition of Seruice Line, the total `mount billed for e`ch is displayed, anc the minimum of there three values disolays in the calcul`ted field.