topic Set Analysis: Weird Dimension Bug in App Development

Set Analysis: Weird Dimension Bug

SonPhan — Sat, 16 Nov 2024 17:29:33 GMT

Hello Guys,

i have a problem regarding set analysis.

I prepare a simple demo app.

I came across an error, which I do not understand, I think in my eyes I have built everything logically correct.

The third chart should be a pie chart, if the dimension Vendor is selected as a filter, it should take the upper right chart, otherwise the upper left chart.

Hope you guys can help me with my problem!

Thanks a lot .

Son

Re: Set Analysis: Weird Dimension Bug

GaryGiles — Fri, 12 Feb 2021 11:46:14 GMT

@SonPhan

To get the functionality that you have described in your 3rd chart, use the following expressions:

Dimension:

=aggr({1} if(Only({1<Vendor=P(Vendor)>}Vendor)=Vendor,Vendor,'Other'),Vendor)

Measure:

sum({$<Vendor=>} Sales)

If you select one Vendor, it will present that vendor and group the rest into 'Others'.

Note: If you select 2 Vendors, it will present those 2 vendors and group the rest into 'Others'. I think that gives you more functionality.

Re: Set Analysis: Weird Dimension Bug

SonPhan — Fri, 12 Feb 2021 12:16:26 GMT

@GaryGiles

Thank you ! This is much better as expected!