SOLVED How to calculate month over month growth

[Madeleine]

Hi,

I need your help to calculate month over month growth

I know the formula- "subtract the first month from the second month and then divide that by the last month's total. Multiply the result by 100" but I don't know how to apply it in Didgash.
Thank you,
Madalina

[Madeleine]

Hi Gregory,

it only works in this format:
<Value(sum)>/<Month-1(NO_AGG)>-1

Thank you,
Madalina

[GregoryBiraud]

Hi @madalinamisca,

First you have to create a derived measure in your dashbord. Use the assistant mode to create "Month - 1" formula.
Then, create a new derived measure in advanced mode with this formula :
(measure - measure (M - 1) ) / measure (M - 1)

Then change the format to "Percent" (it will multiply it by 100)

Gregory

[Madeleine]

@gregorybiraud a dit dans How to calculate month over month growth :

(measure - measure (M - 1) ) / measure (M - 1)

Thank you for your support and response but unfortunately is not working

I have created "Month-1"

• associated measure "value"
• aggregation: sum
• dimensions per axis: "dateyearmonth"
• filter: off
• transformer on: shared function - "Month-1"
• exploration: none

and I have created "(measure - measure (M - 1) ) / measure (M - 1)":

(<value(sum)>-<Month-1(NO_AGG)>)/<Month-1(NO_AGG)>

but the result is NAA

[GregoryBiraud]

@madalinamisca could you send me some screenshots ?

[Madeleine]

Thank you again for your help.

[Madeleine]

Hi Gregory,

it only works in this format:
<Value(sum)>/<Month-1(NO_AGG)>-1

Thank you,
Madalina