3 Replies Latest reply: Oct 9, 2018 3:26 AM by Jana Jakubcova RSS

    Cumulative chart

    Jana Jakubcova

      Hi Team

       

      I would like to create dynamic cumulative chart which has revenue split per weeks. Right now, we are in week 1, from tomorrow, we will be in week 2, the cycle continues as this, every Tuesday new week enters (so it should be adding dynamically). I would like to show only those weeks which are active (however on x axis I still want to see weeks 1-13, just not displaying revenue which should not be there), right now it is showing me the same revenue from week 1 across all 13 weeks (i would like to neglect that revenue). I have variable telling me the current week number, but somehow it does not work.

       

      Many thanks in advance

       

      ex 1.png