Box plot chart takes a long time to load

[wailengwoo]

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

[CathyRDuvall]

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.

[wailengwoo]

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

[CathyRDuvall]

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)