New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save \$400. Learn More
Highlighted
Not applicable

I want to get Avg of a Ticket on every day basis.

Hello All,

I am stuck in this whole excel complexity.How I am going to Integrate on Qliksense???

I want to load an Excel file every day as Tickets are getting registered everyday what the management wants is getting Average of tickets which are having category 'Down call'.

What issue I am facing is how I am going to add everyday avg into previous day and taking out the average of all days passed in that month.

 Date Total Ticket Formula applied:-"100-(Total Tickets/13700)*100= UPTIME%" My main Problem!!!How to make this work? FINAL 01-01-2016 2118 84.54014599 avg(e2)= 84.54014599 02-01-2016 2398 82.49635036 avg(e2+e3)= 83.51824818 03-01-2016 2476 81.9270073 avg(e2+e3+e4)= 82.98783455 04-01-2016 2843 79.24817518 avg(e2+e3+e4+e5)= 82.05291971 05-01-2016 2932 78.59854015 avg(e2+e3+e4+e5+e6)= 81.3620438

#Color coded for better understanding.

The Final Value will be most important as an KPI whenever the dashboard is opened as UPTIME% will be displayed according to that particular date adding and carrying out average of all previous date and current day.

Attaching the main excel for easy understanding.

Important Column: Category=Down Call, Actual Logged Date, Status=Open and Paused

Please Help me in understanding how this problem can be resolved.

Regards,

Siddharth Gupta

+919930401207.

1 Solution

Accepted Solutions
MVP & Luminary

Re: I want to get Avg of a Ticket on every day basis.

You could use interrecord-functions like above() for it. Try this one:

rangeavg(above(100-(Total Tickets/13700)*100, 0, rowno(total)))

- Marcus

3 Replies
MVP & Luminary

Re: I want to get Avg of a Ticket on every day basis.

You could use interrecord-functions like above() for it. Try this one:

rangeavg(above(100-(Total Tickets/13700)*100, 0, rowno(total)))

- Marcus

Not applicable

Re: I want to get Avg of a Ticket on every day basis.

Where I have to insert this script?

and I dont have an average column for better understanding I have given example. What I have is you can see in excel attached to this discussion.

please look towards it once.

MVP & Luminary

Re: I want to get Avg of a Ticket on every day basis.

This would be a normal chart-expression.

- Marcus