GetFieldSelection Calculating Averaging

[lucasx15]

I would like to know if there is the feasibility ofhave the filter object I created on the side called Box calculate the average for every two items I select.
Currently this line graph when selecting two filters next to it plots both filters. I did this using the conditional:

=if(WildMatch('"' & Replace(GetFieldSelections(BOX_FILTER), ', ', '","') & '"' ,'*Room Center*'),1,0)

[Chanty4u · Accepted solution]

Try this

=RangeSum(Aggr(Avg(Measure), Floor(RowNo() / 2)))

[lucasx15]

Thank You!!!😀