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.
I was looking forward for such calculation.
If we are using the Excel data connection can we create the such calculated field in Tableau on Dimension/measure.
to show pop of showing No data or Sorry as such.
It will be grate help.
Hi Graeme Frost
Your idea is good, but it would only work for cases when you have a few values for the dimension (e.g. the company names) and you know all the companies in advance. It wouldn't be very useful though when we have millions of customers or sales items.
Sorry for the delay - I didn't see your post. Yes you could do it with joined sheets in excel, providing you can get a list of all (say)companies
Sorry, I don't really understand why there would be any restriction. We are dealing with hundred of thousand of companies - and it works fine. With millions of (say) companies you presumably have the infrastructure that will handle that and it will work fine. Especially if you create an extract (we do) - Tableau handles that great. Yes you do need to have a list of all possible values (eg a Company or customer master table).
Hi Graeme Frost,
I think it would be better if you may please attach a screenshot of the process / output so the solution may become clearer.
What I imagine now is, if I use the solution you are proposing, then I will have in the pane each company with the message 'Sorry - but we don't not have data for this company' next to it.
So, if I have 1 million companies, the output pane (let's say a crosstab) will have 1 million rows with the company_id and the output message "no data found". Right? If yes, then it wouldn't be feasible to print this output as we can't print 1 million rows, it would look better if we just have 1 row saying 'no data found for ALL companies'.
Thanks a lot for the help.
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)