1 of 1 people found this helpful
If you created a dashboard, it would help but not completely solve the situation - in a tiled dashboard with titles turned off on all sheets you would get a blank top row, only 4 on the middle row, but you would get 7 & 9 together on the bottom row.
Another approach would be to create a floating dashboard with a text box containing "No data to display" (or similar message) with the real data being floated on top. That way the users see the data or the message depending on their access.
Thanks you. I tried the single dashboard multiple worksheets approach earlier, which was a little slower, Loading separately one after other seems to be faster. So we decided to keep multiple iframes. I like your second approach. Which seems to work theoretically so far, but being slightly finicky. Some times 'No Data' sheet peeks over.
I have to test, how this would look in portal, for different browser sizes. We have users with wide array of resolutions and devices.
It would be nicer if that sheet would only show when there is no data. Not sure if there is a sheet swapping solution to this.