Qlik Community

Qlik Sense Cloud Discussions

Not applicable

How to setup trend with Avg count per month

Hi Guys,

I have a tricky question where i can't find a solution, below you can see a chart where i display some data (Helpdesk) :

Capture.PNG

On this chart :

Dimension is  :
=Request_MonthYear

Mesure 1 Open ticket      :   

Count({<ACCOUNT_ID={$(vCompany)},Request_Month={'*'},Request_Quarter=,Request_Year={'*'}>}distinct(sr_id))

Mesure 2 Active ticket  (Backlog)   :

count({<ACCOUNT_ID={'$(vCompany)'},status_class={'Open'},Request_Month=,Request_Quarter=,Request_Year=>}distinct(sr_id))

Reference line (green)   :
=Avg(Aggr(Count(Open_Tickets_Dayes),Request_MonthYear))

As you can see everything is working well, what i am looking for is to have the reference line setup for the last 4 month only.
So this line will be an objectif for the help desk team that will adapt every month compare to the last 4 month.

The goal is to assign an objectif that is below the AVG number of ticket open the last 4 month

Any idea ?

1 Reply

Re: How to setup trend with Avg count per month

Not sure I completely understand your goal. But to show the reference line for only last 4 months, may be you need this:

=Avg(Aggr(Count({<DateField = {"$(='>=' & Date(AddMonths(Max(DateField), -4), 'DateFieldFormatHere') &  '<=' & Date(Max(DateField), 'DateFieldFormatHere'))"}>}Open_Tickets_Dayes),Request_MonthYear))

Community Browser