I have had a similar issue and solved it....so you may be able to use this approach. It is dependant on you using a database - and being able to create a view.
- Create a view where your input table is Unioned to a set of dummy records - 1 for each (say) company. The measures will should be 0 so they don't affect your base data - but the Company ID/Name will be present.
- In your 2nd worksheet create a calculated field something like this:
if Total(sum([Value])) = 0
Then 'Sorry - but we don't not have data for this company'
3. Then put the calculated field as the first pill on the Columns Shelf. Fomat the text.
The message will appear across the top. Not overly eloquent - but at least it is claer for the user what is happening.
I have the same issue. Is it possible to explain with the attached worksheet? I could not get it to work, unfortunately.
In the attached worksheet, if you select last 1 week, there will be no data, and I want "No data exists" message to be displayed.
How is that possible in this case?
Thanks for the help.
Book3.twbx.zip 52.2 KB
If a view has no records it disappears. But that same view placed on a dashboard will retain its title and caption. I have a daily report that finds discrepant data but if there isn't any I don't want users thinking the report is broken. So I hard-coded the caption as attached, which is adequate for this application, no padding or other tricks required.
So the line that says "if sample list is blank it means no missing PDOs were found" is going to appear on the screen even if the view has records?
Correct, the caption is fixed. If there are records they will appear above the caption so I don't think users will be confused or annoyed. I did try data padding and calculated fields to make this conditional but it wasn't worth the effort in this case. In other situations I have spent the time to get the data padding working perfectly but it's a hack.
Here's one approach that was posted today:
It basically just puts a floating text box behind the sheet in use, when no data is shown, the text box behind the sheet is displayed. Very simple, and easy to use in some scenarios (granted, it won't work in all cases/layouts)