Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You can use an As-Of table to create a running monthly average. See these pages for more information:
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!