Hey there,

this is a thing that boggled me for a while in Analytics:

Can I limit what's displayed in a chart without filtering out underlying data?

I have a simple table with historic sales data (date - revenue) and want to create a chart to show the accumulated revenue so far. So I create a chart, put the date in the x axis and the revenue in the y axis and set it to calculate the running total. This works amazingly in Analytics. But things get messy if I want to show less than the whole dataset, for example the last 3 months.

I learned in Analytics you would need to apply a filter to limit the shown data, but the problem is: filters filter. :D

So the running total of revenue would start at zero at the beginning of the 3 months period, which wouldn't be correct, investors would be unhappy etc. :)

Can this problem be solved directly in charts? (So far I created Query-Tables and got headaches)

Thanks in advance!