cancel
Showing results for 
Search instead for 
Did you mean: 

How to exclude Block (Chart) that does not have data in it?

former_member587907
Discoverer
0 Kudos

Hi,

I was assigned a task to make the blocks that consist chart dynamic. Meaning, when the block does not have data in it, it should not display itself at all. Although, in my case the report contain bunch of blocks that has no data in it and still display as empty space. This report has been created long time ago and I do not understand the logic behind it. Seems like the blocks are hard coded on this report. Can someone please help?

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member587907
Discoverer
0 Kudos

That would not be dynamic though. The requirements is not to have the block appear if the data does not exist for that specific Region.

The charts are based off region and data is distributed among the business unit. Certain region does not have any data to populate.

Is there any solution to this?

Thanks

amitrathi239
Active Contributor
0 Kudos

Right click on chart/Table->Format Table->check the option "Hide when empty"