topic Re: Set Analysis in table not working in App Development

Set Analysis in table not working

jalanhart — Wed, 11 Sep 2024 17:43:50 GMT

Hello,

I am wondering about reasons why a set analysis would not work in a table when I add a field as a dimension.

For example I made a table with just one field as a dimension. this is a list of site locations. I only want to show one site location in the table.

So i used this expression ={<SITE = {'85'} >}SITE and it doesn't filter anything down.

What could be the causes of this not filtering correctly?

Re: Set Analysis in table not working

MatheusC — Wed, 11 Sep 2024 18:11:51 GMT

It was a little confusing, you are using the filter in one dimension?

If this is the case, see as follows with the Only function. The Only expression will return only one possible value according to its aggregation field.

In the expression, if its value is a string, you can keep the quotation marks, if it is a number value, you do not need the quotation marks:

Aggr(only({<SITE={'85'}>}SITE), SITE)

- Regards, Matheus