Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ExpertiseLogic:
WeekStart current previous difference(currentweek-previousweek) metric
12-march-2017 8 5(this value is 5-march-current week data) 3
19-march-2017 10 8 2
26-march-2017 15 10 5
Out Put Table should like this :
Date Tickets
12-march-2017 3
19-march-2017 2
26-march-2017 5
could you please suggest me how can i achieve solution for this?
Thanks in Advance
Hi sunny
In the second of closed ticket set analysis where is last week expression ?
This will just subtract th ope tickets - closes tickets which is partially correct .but my requirement is to subtract last week in closed ticket from open tickets .
Thanks a lot Sunny Sir,
This worked for you just rock
Glad it worked...you understand the logic now?