Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 (1)
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