Hello everyone!
I have a project that uses two data sources, one from a JSON file and one from a tde view, when I select a filter from the JSON file and place it in the filter area, the data showed is correct, but then if I select a filter from the secondary data source (my tde view), the data comes with a null value.
I noticed that this also happened in the reverse order I explain above (I first selected a field from the tde view and then from the JSON file), but in this case, the fields from the JSON file will be null.
I tried to use Conditions, Calculations (IF ISNULL (field) THEN "" ELSE field END), but nothing worked as I expected.
Also, I tried using Sets, but Sets only works for the primary data source.
Here I put two print how the null values appear to me.
The first image selecting a filter from JSON data source
The second image I selected from tde view that I used
And this will happen for every dimension from the secondary data source.
Some links that I found helpful, but that doesn't work to me:
Removing Null Values from Filters - YouTube
How to Have Sets with Your Secondary (Data Sources) | Drawing with Numbers
https://kb.tableau.com/articles/howto/hiding-null-values-from-quick-filters
How to switch primary and secondary data sources
So, if someone has some ideas, please, reply to this post!
In time, I wish happy holidays for everyone here!
Hi Gabriel,
You can't remove "Null" values or do "Only relevant values" from the field which are coming from the secondary data source.
What Matthew has told it can be applicable if you are doing it with the primary data source.
You can either join the data or change secondary data source to primary and primary data source to secondary to remove nulls.
Please let me know if this helps.
Thanks,
Shruten
