Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Cumulative Sum by User not working properly

Hi there!  I want to look at the cumulative amount of savings ([savings]) by user ([external_payment_id]) over time ([event_month]). It's working for 1 or 2 specific users when I filter the plot ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous, thank you so much for taking the time to test the issue on your own! I believe that there are some issues when I take into acconts a lot of users or some weird users I have in my database.

    it's good to know that I got the right way though! 

     

    thank you so much! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    hi Greg_Deckler, thank you for replying!

    I've tried your solution and it looks like it's working properly.

    thank you so much! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    hey Greg_Deckler, I tried the running total, but it looks like it doesn't cumulate sum properly. 

    here is the code I used to get the following chart:

     

    RunningTotalSavings2bis =
    CALCULATE(
    DIVIDE(SUM(monthly_user_metrics[savings]), DISTINCTCOUNT(monthly_user_metrics[external_payment_id]),0),
    FILTER(
    ALL('monthly_user_metrics'[mss]),
    'monthly_user_metrics'[mss] <= MAX('monthly_user_metrics'[mss])
    )
    )


    do you have an idea why?

    thank you so much!

    Jacques