Class range with if condition and multiple 'and' is making the charts slow

joybratas1 — Tue, 20 Sep 2022 05:22:57 GMT

Hi,

I have multiple charts that are affected by multiple sliders.

For achieving that in dimension I used something like-

class(if(slider1< 'max value of the slider' and slider1> 'min value' and slider2<'max value' slider2>'min value' and slider3<'max value' and slider3>'min value', Field)

Similarly in measure count(if (slider1<'max value' and slider1>'min value'...... , field2) )

So this sort of if condition expressipn is used for multiple charts and kpis in the dashboard.

So everytime some slider value is changed or any selection made it gets slower. Is there a way I can improve the performance. I have removed all strings and used just flags, removed all unused columns.

The similar expressions are repeated in all the charts and kpi's so everytime it is calculating. I believe this is the bottleneck, but I am not sure how to fix it.

Any help is appreciated.

Re: Class range with if condition and multiple 'and' is making the charts slow

marcus_sommer — Wed, 21 Sep 2022 06:14:45 GMT

I suggest to change the (nested) if-loops to set analysis statements like:

count({< Field1 = {">=slider1<=slider2"}>} Field2)

- Marcus

topic Re: Class range with if condition and multiple 'and' is making the charts slow in App Development

Class range with if condition and multiple 'and' is making the charts slow

Re: Class range with if condition and multiple 'and' is making the charts slow