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

[#1]

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

siddharthgupta2792@gmail.com    

+919930401207.

[marcus_sommer · Accepted solution]

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

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

- Marcus

[#3]

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.

[marcus_sommer]

This would be a normal chart-expression.

- Marcus