Choose Language Hide Translation Bar
Highlighted
tom_abramov
Level IV

Collapse empty charts while using "by" and excluding rows

Hi,

Is there any way to remove/collapse/hide empty charts due to the excludings?

In the following example, I would like the outline of age=14 to be collapsed automatically if the user excludes all rows of age 14.

The exclude may occur by Row Filter or manually, on column of age or any other columns.

I've tried to loop over all frame boxes and collapse if it doesn't have points.

It doesnt work because I use Row State Handler and the charts are refreshed AFTER the handler runs.

Thank you.

Screen Shot 05-04-20 at 04.44 PM.PNG

0 Kudos