Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Avg RangeAvg

I have a measure that I am trying to create.  It will be used in table to show average of total sales for the day for the previous 30 days (rolling).  So far I have the following expression:


Avg({<Date = {">=$(=Date(Max([completed_date.autoCalendar.Date]))-30)))"}>}Sales)


The issue with this formula though is that it calculates the average of order totals over the last 30 days, not total sales for day average.  Any edit to this expression that will get me closer to correct average I am searching for?  Attached table where I would like to use measure.InkedScreenshot 2018-10-08 15.44.36_LI.jpg

0 Replies