How to retrieve the last occurrence in Set Analysis

08748190 — Mon, 05 Aug 2019 20:36:04 GMT

I want to mesure yearly membership full-time of salaries,there is some salaries have diffent part-time from period to period.
For exemple: salary x have in 2018 part-time=0,9 and in 2019 part-time =0,5
the issue here that i get the sum of 0,9 + 0,5=1,4 but in my case i want to get the last occuenrce 0,5 not the sum of part times,see the attached screenshot.

My Set analysis is :

Count({$<__Pivot_Intervall_PeriodType ={'Intervall'}

, __Pivot_Intervall_Role={'EntreeSortie'}

, __Period_id = {'$(vdate_analyse)'}

,[__Status.FR] = {'(Actif)'},

[__Contract_Type]-={'IN','PS','TV','ST'}>}

distinct(__FOLDER_ID) )

( (Sum({$<__Pivot_Intervall_PeriodType ={'Intervall'}

, __Pivot_Intervall_Role={'EntreeSortie'}

, __Period_id = {'$(vdate_analyse)'}

,[__Status.FR] = {'(Actif)'},

[__Contract_Type]-={'IN','PS','TV','ST'}

distinct(__FTE)))

So my question how i get the last occurence?

thank you in advance.

Re: How to retrieve the last occurrence in Set Analysis

miskinmaz — Mon, 05 Aug 2019 07:34:53 GMT

You need to filtered out the max date in set analysis, something like:

Count({$<your_dateField={"$(=max(your_dateField))"},.....,etc>} distinct(__FOLDER_ID) )

topic How to retrieve the last occurrence in Set Analysis in App Development

How to retrieve the last occurrence in Set Analysis

Re: How to retrieve the last occurrence in Set Analysis