Skip to main content
Solved

Average MRR invoiced per cohort

  • Sep 29, 2023 1:37 PM UTC
  • 2 replies
  • 664 views
Master Author
Forum|alt.badge.img+7

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

View original

    2 replies

    Benoit
    Community Manager
    Forum|alt.badge.img+17
    • BenoitCommunity Manager
    • Community Manager
    • Oct 2, 2023 7:24 AM UTC

    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
    Master Author
    Forum|alt.badge.img+7
    • Cedric LJMaster Author
    • Author
    • Master Author
    • Answer
    • Oct 2, 2023 7:38 AM UTC

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

      Ask your question here!

      Terms & ConditionsAccessibility statement