Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try this
=RangeSum(Aggr(Avg(Measure), Floor(RowNo() / 2)))
Thank You!!!😀