I am using periodOverPeriodDifference(sum({MRR}) as My calculated field but the issue here is.
I need to Calculate the Expansion and Contraction MRR of my customers
Lets say if name of the above calculated field is MoM-Value
Name Jan Feb March
A 0 10 20
B 0 10 10
C 0 20 10
Expansion should be
JAN FEB MARCH
ALL 0 40 20
Contraction should be
JAN FEB MARCH
ALL 0 0 20
But my results is
JAN FEB MARCH
ALL 0 0 0
I tried to create a boolean column with MoM-Value > 0 but due to this aggregation, This is not working as expected
Max
2
are all of your date fields grouped to the month?
Did you use the month period as well?
Finally can you tell me how contraction is 20 on march because it seems like the totals are 0,40,40.
So it should be 0,40,0 for expansion and 0,0,0 for contraction
1 Like
@Max Yes I used that is results I mentioned above.
I need expansion as
JAN FEB MARCH
A 0 10 10
B 0 10 0
C 0 20 0
ALL 0 40 10
I need like this But If we are using the that function
@Max Can we pass any condition here (Any TRUE/FALSE)
Max
5
@Sanjay-dev-ds
You mean like this?
ifelse(periodOverPeriodLastValue(distinct_count(({client_id[users]})),{arrival_timestamp},MONTH,-1)<0,'contract','expansion')