Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ccsimo16
Contributor III
Contributor III

Average number of orders placed in a month

Hi 

Is it possible to report on the average number of orders placed in a Month from rolling 12 months?

For example 

Jan 40

Feb 50

Mar 40

The rolling average would be 43

Thanks for your help

 

Labels (2)
3 Replies
dplr-rn
Partner - Master III
Partner - Master III

Do you mean 12 months back from today?
Yes. it should be . share some details
give sample data close to you actual data and a sample output of what you want too
martinpohl
Partner - Master
Partner - Master

Hi,

attached find an example

Regards

ccsimo16
Contributor III
Contributor III
Author

Hi Martin Pohl
Thanks for the example. I would like a single value. Using your example if the current month was March 16 the value would read 23,33
Thanks