I think instead of using date filter use date as a parameter. That will give you more control over your sheets. After that you should create a set of those dates which don't provide any data on any of your sheets in the dashboard.
Then you can go ahead and create a calculated field which says: IF SET THEN "THE MESSAGE YOU WANT TO DISPLAY" END.
You can use this calculated field and drag it on to the Text mark. Inside the dashboard just bring this sheet to the appropriate place on a particular sheet where you want to display the message. Attaching a .twbx file always helps.
I cannot hardode which dates will give be blank widget.
I have data for 18 years and there could be many combinations of year/month which could result into blank widget.
Is there a way to dynamically check if there is no data show 'Message'?
Also I have 6 widgets which are all different sizes(automatic). How will I place the blank sheet?
Have you consider using a floating container that states "No Data to Report" which you put behind your dashboard graph?
If you have no data, users will see the "No Data to Report" message; otherwise it will be covered by the graph of data.
Naturally, this only works in the case where your entire graph is absent, rather than "cells" where no data exists.
Then the other way is to use a floating text object behind your sheets in the dashboard.
I have 6 widgets and each widget is of different size.
Overall dashboard size is automatic.
Does that mean I create 6 blank floating sheets and place with exact size on each widget?
Will the placement work ok if user opens the dashboard on laptop v/s wide screen monitor?
Also how do I take the sheet behind the widget? I tried 'Send to Back' option but doesn't work.
I created a worksheet 'No data message' and tried placing as floating container.
1 of 1 people found this helpful
Vishal just create a new dashboard and then place different floating text objects, not the worksheets with a calculated field on text which says "No Data" within that dashboard to different places for all the 6 worksheets. Then drag your worksheets above those text objects. So you should have 6 floating text objects beneath those 6 worksheets within your dashboard.
This will solve your problem.
looks like i am missing something, i first placed a floating text and then placed my widget ontop of it.
'No data message' shows even when there is data in widget.
Let me show you some screenshots.
This is when everything is selected.
This is when I uncheck the all option
This is my floating text box object
Then I again brought my sheet on the dashboard with categories with no category selected
And then when I click on all this is what happens
I hope this helps.
Kashish, what do you place first?
I placed 'No Data' text and then worksheet on top of it. Still 'No data' will be visible when there is data.
Do I have to apply dashboard filters to the floating text?
Vishal you need to place the floating text boxes first on your dashboard for each sheet. And then the respective sheets over the text boxes.
Vishal: please note that the automatic layout can wreak havoc with floating text boxes. While it may look good on your screen, moving to a different sized monitor may reposition the boxes, causing awkward effects.
If you know you'll only be working from your computer, you should be fine. Otherwise I recommend setting a specific layout orientation to ensure your floating boxes stay where you put them!