3 Replies Latest reply: Sep 24, 2015 1:57 PM by Adam Krepistman RSS

    Bar Chart - Dimension Limits & Accumulation

    Jason Liau

      Hello!

       

      I have the following example table:

       

      DateYDateQAmount
      2014Q310
      2014Q45
      2015Q10
      2015Q220
      2015Q315

       

      If I want to create an accumulative bar chart that only shows 2015 but instead of starting at 0, I would like it to start at the sum of the previous dates (15 in this case).


      What I also experimented with is to load the entire dataset and limit the dimension, but it doesn't have an option to limit the last x amount of values, only the first and I can't figure out how to position the Other bucket at the beginning.


      Thanks in advance!


      -Jason