Average over a time series

[firmographs]

I have data with daily values, plotted on a chart.  Show in the attached screenshot.   

I'd like to show this data as monthly average values, rather than each discrete point.  

What is the best way to achieve this?

[Gysbert_Wassenaar]

You can use an As-Of table to create a running monthly average. See these pages for more information:

• https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-oth...
• https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

[firmographs]

The solution ended up being the following.

In the load script, we created a new field.

Load *,
Month([Month Deal]) & ' ' & Year([Date Deal]) as [Month Year Deal];

We used this as a dimension in our chart and counted the items as our measure.  

Next challenge was since this is a string rather than a date our chart it wasn't sorting properly.  

To fix this in our bar chart, we sorted by max([Date Deal]).

All set!