I have this problem, i change my final workbook to show you my problem, i have a simple calculation, count if a field is null
and this, show me this graph using an date field
and choose a year.. for example 2013 and right click y select view data
and show me this window...
But if a select "Subyacente" option, tableau don´t show me the 419 rows, tableau show all data of data calculation
another problem if a use this graph in a dashboard, in an action to filter to a table, don't show me real data, the rows have not null values in the "Cons Final" field.
Excuse me my bad english....my natural language is spanish
Thanks for you help !
You may put your inner filter in it's own calculation like this:
// Ano modified dim
IF ISNULL([Cons Final]) THEN [Ano] END
This would be a Dimension (like original [Ano] but a sub-set of it).
Place it to Filter shelf and Exclude NULL values.
Hope it could help.