Calculation problem

[#1]

Hi all,

Please help me out

i have scenario on below example

I want to calculate All Id time difference between status "Assigned " to status "Resolved".

But i have some condition so i am not able to calculate.

Conditions:-

• Exclude the public Holiday time.
• Exclude time all “Pending” status to immediate” Inprogress “ status time
• Exclude time Sat Sun
• Exclude time when Id in “Queue-Other”
• Priority will change then calculation will restart again from the place of priority change.

ID	Priority	status	date	queue
1001	P1	Assigned	30-01-2015  08:00:00 AM	Queue-Own
1001	P1	Inprogress	30-01-2015  09:00:00 AM	Queue-Own
1001	P2	Inprogress	30-01-2015  10:00:00 AM	Queue-Other
1001	P2	Inprogress	30-01-2015  11:00:00 AM	Queue-Own
1001	P2	Pending	30-01-2015  12:00:00 AM	Queue-Own
1001	P1	inprogress	30-01-2015  01:00:00 PM	Queue-Own
1001	P1	pending	30-01-2015  02:00:00 PM	Queue-Own
1001	P1	pending	30-01-2015  03:00:00 PM	Queue-Own
1001	P1	Inprogress	30-01-2015  05:00:00 PM	Queue-Other
1001	P1	Pending	30-01-2015  06:00:00 PM	Queue-Own
1001			30-01-2015  07:00:00 PM	Queue-Other
1001	P1	Inprogress	30-01-2015  07:30:00 PM	Queue-Own
1001	P1	Resolved	30-01-2015  12:00:00 AM	Queue-Own
1002	P1	Assigned	31-01-2015  08:00:00 AM	Queue-Own
1002	P1	Inprogress	31-01-2015  09:00:00 AM	Queue-Own
1002			31-01-2015  10:00:00 AM	Queue-Other
1002	P1	Inprogress	31-01-2015  11:00:00 AM	Queue-Own
1002	P1	Pending	31-01-2015  12:00:00 AM	Queue-Own
1002	P1	inprogress	31-01-2015  01:00:00 PM	Queue-Own
1002	P1	pending	31-01-2015  02:00:00 PM	Queue-Own
1002	P1	pending	31-01-2015  03:00:00 PM	Queue-Own
1002	P1	Inprogress	31-01-2015  05:00:00 PM	Queue-Own
1002	P1	inprogress	31-01-2015  09:00:00 PM	Queue-Own
1002			31-01-2015  10:00:00 PM	Queue-Other
1002	P1	Inprogress	31-01-2015  11:00:00 PM	Queue-Own
1002	P1	Resolved	31-01-2015  12:00:00 AM	Queue-Own

Regards

[Anonymous]

Hi balram,

You can create expressions with "Set Analysis" to exclude certain values.

Set Analysis: syntaxes, examples

You can share the file to help .qvw better.

Regards.