Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Accumulated

Hello to see if you can help me with this doubt I have. I have a table with ID, dates per week, and performance (which is already calculated to me), I need to add up every week to get the accumulate...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Hello

been reviewing the formulas and it's not exactly what I want. I'm explaining the most wrong. I don't want the accumulated one I want the global. For example:

1. If filter on the slicer dates date 04-01-2021 in the gauge graph should give me 18% (which is the performance of that week) but if I filter two weeks 04-01-2021 and 11-01-2021 (18 % and 53%) and the graph of guge should give me the overall of the two of them I do not know if it is the sum between the weeks 36%?

and if I don't filter any date I should give the performance globar in the 9 weeks

I don't know if you'll explain it to me right.

Best regards

Thank you

Stephanie Falvay

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Syndicate_Admin 
    Thank you for your feedback.

    I am not sure if I understand correctly, but is it OK with you to share how you calculate the performance? Without knowing this, I cannot know what is 100%. 

     

    If I may just assume the 5.58 is 100%, then the first week is not 18%