I tried to calculate the average MRR invoiced per cohort but it’s not working.
i tried to drill down but dit not find the solution.
For example: MRR by cohort for Cohort 14 in jan 23 is equal to 4315€ and '# MRR invoiced by client is equal to 6.
The calculation should do 4315 divided 6, but it’s not.
Can you help me ?
Thanks
Hi Cedric,
What is the dimension structure of your source blocks?
Are they aligned?
if you open the formula playground and switch to automatic mode, do you notice a structure difference?
If the cell is not divided by the second block, can you ensure the data is present on the second block?
Hope it helps.
Best,
I have the same dimensions for both metrics, so the problem is not coming from this part.
From what i see the calculation done for each client is good.
I change the formula aggregator from sum to average.
Looks like it’s making the trick :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.