topic Re: Box plot chart takes a long time to load in App Development

Box plot chart takes a long time to load

wailengwoo — Sat, 16 Nov 2024 07:11:27 GMT

Hi all,

I have included a calculation condition in the box plot chart where it will not display until either the month or year is selected from the filter pane. The box plot chart is supposed to show the condition message when I access the sheet but it is showing the loading icon and it took a long time to load before it shows the message and sometimes cause the filter panes to load slowly and not able to select any filters until it finishes. I am using June 2018 Patch 1 release.

Anyone else encounter such problem?

Regards,

Wai Leng

Re: Box plot chart takes a long time to load

CathyRDuvall — Wed, 28 Nov 2018 17:51:46 GMT

Hi,

Make sure you are using Set Analysis expression in your measure.

I just tried one with and one with just Sum(Sales)and it took so long I hit cancel.

Re: Box plot chart takes a long time to load

wailengwoo — Thu, 29 Nov 2018 02:41:02 GMT

Hi,

Yes, there is a set expression in the measure. The problem is it should not load when there is a calculation condition that requires a filter to be selected before calculating.

regards,

Wai Leng

Re: Box plot chart takes a long time to load

CathyRDuvall — Thu, 29 Nov 2018 14:12:37 GMT

You will need to start the set expression as:

The '1' in the expression below will ignore any selection made.

Sum({1>|<[include modifiers here>}Sales)