Skip to main content
Solved

Average MRR invoiced per cohort

  • September 29, 2023
  • 2 replies
  • 328 views
C
Master Author
Forum|alt.badge.img+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
 

 

Best answer by Cedric LJ

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

    2 replies

    Benoit
    Community Manager
    Forum|alt.badge.img+15
    • BenoitCommunity Manager
    • Community Manager
    • October 2, 2023

    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,

    Benoit - Pigment wizard
    C
    Master Author
    Forum|alt.badge.img+5
    • Cedric LJMaster Author
    • Author
    • Master Author
    • Answer
    • October 2, 2023

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

    Benoit

    Ask your question here!

    Terms & ConditionsCookie settingsAccessibility statement