Calculation help for Wokload????

[amit_saini]

Hi Folks ,

I'm facing one issue for calculating Workload based on no. of Open and Closed ticket.

I'm having date which is showing ticket status as open as closed . For example for 01/01/2014 I'm having Open=1 and Closed=0 , so work load =1 , similarly on 02/01/2014 I'm having Open =2 , closed =2  , so workload =1 (it should include previous day open ticket in calculation every time).

My Work Load  calculation should be  opened – closed + running total value from previous day

Please see below :

	Opened	Closed	Work Load
01/01/2014	1	0	1
02/01/2014	2	2	1
03/01/2014	5	1	5
04/01/2014	2	1	6
05/01/2014	0	2	4
06/01/2014	0	4	0
07/01/2014	3	1	2
08/01/2014	3	1	4
09/01/2014	2	1	5
10/01/2014	6	3	8
11/01/2014	1	1	8
12/01/2014	0	1	7
13/01/2014	0	0	7
14/01/2014	1	0	8
15/01/2014	1	2	7

Please help me how to reach to this kind of solution.

Thanks in advance,

AS

[#2]

HI,

In Pivot chart, write below expression for Work Load:

Rangesum((Opened - Closed),Above([Work Load])

Hote it help

[sushil353]

Hi,

If you want to resolve it at script side then try below code:

Table:

load Date,Opened,Closed

,alt(Opened-Closed+Peek(WrokLoad),Opened-Closed) as "WrokLoad"

Inline

[

Date,Opened,Closed

01/01/2014,1,0

02/01/2014,2,2

03/01/2014,5,1

04/01/2014,2,1

05/01/2014,0,2

06/01/2014,0,4

..

.

.

];

HTH

Sushil

[amit_saini]

Hi Folks,

Here is my application.

Thanks,

AS

[MK_QSL]

Please check enclosed file showing two solutions...

1) Script End

2) UI end

Hope this helps...

[#6]

Hi,

try this one

RangeSum((Opened-Closed),Above(TOTAL Sum([Work Load])))

it will work.

[amit_saini · Accepted solution]

Hi Folks,

This is working fine :

RangeSum(above(TOTAL Column(1) -Column(2),0,NoOfRows(TOTAL) ))

Thanks,
AS