Anybody can explain how to show each 3 month average line with combo chart. As of know showing individual last 12 months data. I want to display also 3 month average line. Please advise how is it possible.
I'm using Qlik Sense. What i've done and my requirements are below step wise step. Let me know if any other clarification is required.
1) Load 2 fields one is RequestDate and another is RequestID using stored procedure.
2) Drag and drop combo chart Add Dimension RequestDate with Expression formula of display month with year. Add Measure with Expression Count(RequestID). Combo chart display properly.
3) Now i want to add another Measure for average of 3 months (RequestID). How can i display average in combo chart means what expression i have to used for display average. Average will display like attached image.