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
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))))
)
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.
This is not working
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?
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
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?
Confused
Thanks
I don't see any attachment with the above post?
No luck
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))))
)