• Write in the logs
• Measure based on filtered dimensions
• Measure based on explored dimensions
• Objet Global
• Double pass
• Running on any axis

You may use javascript functions in calculated measure, such as "if" test, or even "for" loop.
You can also use DigDash functions to explore the dimensions

Write in the logs

You may display variables, text, measure, dimension in the ogs using the following code :

Example :

What appears in the logs : 

WIth this, you can check and vet the different steps when building your calculated measure.

Measure based on filtered dimensions

• Example:

• Result:
  Dimension Name: Date
  Dimension Name: Product
  Dimension Name: Regions

• Usage:

Can be used if we want to change the rendered values based on the filetered dimensions.

Measure based on explored dimensions

• Example:

• Result:

Dimension Name: Date
Dimension Name: Produit
Dimension Name: Régions

• Usage:

Can be used if we want to change the rendered values if dimenisions are being explored in the graph

Objet Global

• Example:

• Result:

1
2
3
… (one for each line)

• Usage:

Allows you to save values in variables during the execution of the calculated measure

Double pass

• Example:

• Result:

Forces the script to run twice on the calculated measure

• Usage:

On the first run, you can save values in global variable and retrieve the them in the second run to compare them/manipulated them (example with rank)

Running on any axis

Example :  Explore week number (NUM_WEEK) and dates (DAY_DT), we wish to do a running sum on the CA for each week.
! Beware ! Date must be in ascending ordered in the source