Solved

Average MRR invoiced per cohort

  • 29 September 2023
  • 2 replies
  • 62 views

Userlevel 2
Badge +5

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
 

 

icon

Best answer by Cedric LJ 2 October 2023, 09:38

View original

2 replies

Userlevel 6
Badge +12

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,

Userlevel 2
Badge +5

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 :)

Reply