Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
wailengwoo
Partner - Contributor III
Partner - Contributor III

Box plot chart takes a long time to load

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

Labels (1)
3 Replies
CathyRDuvall
Contributor III
Contributor III

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
Partner - Contributor III
Partner - Contributor III
Author

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
Contributor III
Contributor III

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)