Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have the following example table:
DateY | DateQ | Amount |
---|---|---|
2014 | Q3 | 10 |
2014 | Q4 | 5 |
2015 | Q1 | 0 |
2015 | Q2 | 20 |
2015 | Q3 | 15 |
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
can you use the Scale settings for min (for either your dimentsion or expression) and have the min be your expression containing the total for the prior year?
Can you post the result table you expect using your example data?
If you want to do accumulation perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations
Maybe something like this:
if(DateY = 2015 and DateQ = 1,
rangesum(sum({1< DateY = {2014}>} Amount), above(sum(Amount), 0, rowno(total))),
rangesum(above(sum(Amount), 0, rowno(total))))
- Marcus