topic Re: Filter Chart using dimensions only in App Development

Filter Chart using dimensions only

Wahab — Thu, 09 May 2024 19:39:49 GMT

Hi all,

I have this sample dataset from one source. I want to show in a straight chart, just the Store and Systems columns. But I want them to be filtered by the dimension Function that has the value of only 'Fixed Ops'. Any help here would be appreciated, thanks in advance!

Re: Filter Chart using dimensions only

MatheusC — Thu, 09 May 2024 20:21:16 GMT

@Wahab

Is this the result you want to achieve?

To do this, you can use the expression below, removing the 'Report'.

=Aggr(only({<Function-={'Reporting'}>}Function),Function)

uncheck null values.

Regarts, Matheus

Re: Filter Chart using dimensions only

Wahab — Fri, 10 May 2024 13:09:13 GMT

@MatheusC thanks for the reply. I want to only show the Store and Systems column, not the Function column. The results look correct, but when I remove the Functions column, it doesn't filter to just those anymore.

Re: Filter Chart using dimensions only

MatheusC — Fri, 10 May 2024 14:11:31 GMT

Got it, so do this for these 2 dimensions just Store and Systems

Store

=Aggr(only({<Function-={'Reporting'}>}Store),Store)

Systems

=Aggr(only({<Function-={'Reporting'}>}Systems),Systems)

Regarts, Matheus

Re: Filter Chart using dimensions only

Wahab — Fri, 10 May 2024 15:38:11 GMT

Thank you MatheusC!! That worked!!