Set Analysis

[smilingjohn]

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 

[smilingjohn]

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 . 

[smilingjohn]

Thanks a lot Sunny Sir, 

This worked for you just rock 

[sunny_talwar]

Glad it worked...you understand the logic now?