Forum Discussion

jcozens's avatar
jcozens
Regular Visitor
6 years ago
Solved

Create a rolling measure which rebases graphically using the date filters

Hi, 

 

I'm trying to build a line graph which tracks the accumulated growth of sales over any date period selected by the date filters. 

 

I've managed to get the running total measure that allows a daily growth figure which I can plot onto a line graph. However when I change the date range on the filter, the values on the graph (understandably) do not start at 0 but at the accumulated number at that date. 

 

How do I get the running total measure to start calculating from the date selected in the page filters?