Things like this are tricky, but hopefully this solution will work for you. First you need to put those two charts in a layout container so they will automatically fill the space when the other is null:
Then create a calculated field based on the count of classification levels in on the worksheet. The examples are in the attached workbook. Basically how this works is that when the window count of classification level is less than 8 the detail graph will show. When the summary level has a window count of classification level that equals 3 it shows, but otherwise is hidden.
I hope this helps you.
Precisely what I needed. Two questions:
1) Is there any way I can make the legends disappear if they are empty? Or should I just take their labels off and put them in the same layout container as well?
2) I can't seem to get these guys to both go into a layout container together. They are both in a layout container that encompasses the whole dashboard. How do I fix that?
Nevermind, figured it out!
1 of 1 people found this helpful
1) I would do exactly as you suggest and hide the title and put them in the same layout container
This is a horizontal container which is supposed to contain worksheets like [ 1 2 3 4 ], but in order for the trick to work we need to use the horizontal container and stack the worksheets vertically:
Keep the layout container that the whole dashboard is in, just drag another one from the side:
Does that answer your questions?
Yep, thank you! Now to think about how I can use this elsewhere...