# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for
Did you mean:
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

Regards,

Siddharth Gupta

+919930401207.

1 Solution

Accepted Solutions
MVP & Luminary

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

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
Author

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.