topic Re: GetFieldSelection Calculating Averaging in App Development

GetFieldSelection Calculating Averaging

lucasx15 — Mon, 22 May 2023 19:38:08 GMT

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)

Re: GetFieldSelection Calculating Averaging

Chanty4u — Tue, 23 May 2023 02:58:59 GMT

Try this

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

Re: GetFieldSelection Calculating Averaging

lucasx15 — Tue, 23 May 2023 11:23:37 GMT

Thank You!!!😀