Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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.

 

DateTotal TicketFormula applied:-"100-(Total Tickets/13700)*100= UPTIME%"

My main Problem!!!

How to make this work?

FINAL
01-01-2016211884.54014599avg(e2)=84.54014599
02-01-2016239882.49635036avg(e2+e3)=83.51824818
03-01-2016247681.9270073avg(e2+e3+e4)=82.98783455
04-01-2016284379.24817518avg(e2+e3+e4+e5)=82.05291971
05-01-2016293278.59854015avg(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

siddharthgupta2792@gmail.com    

+919930401207.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
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

View solution in original post

3 Replies
Highlighted
MVP & Luminary
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

View solution in original post

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
MVP & Luminary

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

This would be a normal chart-expression.

- Marcus