Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create a graph that shows a rolling 30 day value over the last 30 days for # of orders and $ amount of orders.
In my example, they want to do a 30 day rolling aggregation of order count and order $ over the past 30 days and I don’t know how to put that together in a formula/set logic. So you would only have 30 days on your chart and for each of those days it would show the sum/count of 30 days prior to that date.
So for example, for 03/17/20 , I would want count ( distinct order) where date between 2/17/20 and 3/17/20
for 03/16/20, I would want count ( distinct order) where date between 2/16/20 and 3/16/20
for 03/15/20, I would want count ( distinct order) where date between 2/15/20 and 3/15/20
.
.
.
for 02/17/20, I would want count ( distinct order) where date between 2/17/20 and 1/18/20
Have a look at the following Design Blog post:
https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581
There are some further links in that post to other posts that may be helpful too.
Regards,
Brett