Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Folks,
This is working fine :
RangeSum(above(TOTAL Column(1) -Column(2),0,NoOfRows(TOTAL) ))
Thanks,
AS
HI,
In Pivot chart, write below expression for Work Load:
Rangesum((Opened - Closed),Above([Work Load])
Hote it help
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
Hi Folks,
Here is my application.
Thanks,
AS
Please check enclosed file showing two solutions...
1) Script End
2) UI end
Hope this helps...
Hi,
try this one
RangeSum((Opened-Closed),Above(TOTAL Sum([Work Load])))
it will work.
Hi Folks,
This is working fine :
RangeSum(above(TOTAL Column(1) -Column(2),0,NoOfRows(TOTAL) ))
Thanks,
AS