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 

[Stoyan_Terziev]

Hi John,

I think your desired expression for the last week data only should look like this:

Count({<Year*={">2015"},Status={'OpenTicket'}, Weekstart ={"=$(=Max(Weekstart))"}>} Key)

Keep in mind this will work only if you have the Weekstart field in your default date format. Otherwise you will have to set the format individually.

PS: I'm perplexed by this par: Sum({1<Year*={">2015"}>}0)

This should basically do + 0. Most likely it was placed there so it will force those weeks in 2016 onward with 0es to appear even if no Key values are associated.

Kind regards,

S.T.

[smilingjohn]

This is not working 

[sunny_talwar]

Shouldn't it be just this?

Count({<Year*={">2015"},Status={'OpenTicket'}>}Key) + Sum({1<Year*={">2015"}>}0)

You are just non-cumulating the cumulative distribution... isn't it? 

[smilingjohn]

Hi Sunny sir , 

Hi Sir i want to show a table with the difference of the two expression . And the new table will should show the cumulative with always Subtracting the current week to previous week      . 

I used your expression but that is not giving me the desired result , Need your help on this 

Thanks 

[sunny_talwar]

You can just call me Sunny.

I am not sure I understand what is going on? Can you share an example showing the issue you have?

[smilingjohn]

Confused

Thanks 

[sunny_talwar]

I don't see any attachment with the above post?

[smilingjohn]

No luck

[sunny_talwar · Accepted solution]

Are you looking for this may be

RangeSum(
RangeSum(Before(TOTAL Count({<Year *= {">2015"}, Status = {'OpenTicket'}>}Key) +  Sum({1<Year *= {">2015"}>}0), 0, ColumnNo(TOTAL))),

-Before(TOTAL RangeSum(Before(TOTAL Count({<Year *= {">2015"}, Status = {'ClosedTicket'}>}Key) + Sum({1<Year *= {">2015"}>}0), 0, ColumnNo(TOTAL))))
)