Here I am sharing the snapshot of result expected.
My requirement should be,
For each indicator,we got values from columns result,RR,RE and mapped to specific date in a month.
And few cases,we got more than one date for the same indicator in a particular month,then we need to consider higher value of process id and display that one for that specific month..For example (Below Screenshot)
Here Indicator#2(pink color) came two times in a same month (2023-06) and we need to consider higher value of processid (25) and display in a gallery..
Based on above requirement,I tried few one on my own:
I was able to filter the lastest date for every month..
Screen OnVisible Property:
Set(a,Value(Concatenate(First(Split(Text(DateAdd(Now(),-6,TimeUnit.Months),"yyyy-mm"),"-")).Value, Last(Split(Text(DateAdd(Now(),-6,TimeUnit.Months),"yyyy-mm"),"-")).Value)));
Set(b,Value(Concatenate(First(Split(Text(Now(),"yyyy-mm"),"-")).Value, Last(Split(Text(Now(),"yyyy-mm"),"-")).Value)));
Gallery Item property:
SortByColumns(Filter(ColDataPortal, Value(Period)>a && Value(Period)<=b),"Process_ID",SortOrder.Ascending)
My screen will be looking like totally wrong (Below screenshot)
Please suggest anyone,how to get 6 month data and mapped with right indicator name and display in gallery.(Below screenshot).
