I have a workbook with many sheets/dashboard using 4 global filters. (Field 1,2,3,4).
Also I have a secondary database that I bring into link certain codes and I create the primary code from this.
however, I noticed that if I have data like the following (simplified to only use one global filter - field 1):
Field1 Code(linked to both database)
and the code mapping sheet looks like the following:
Name Code(linked to both database)
With the global filter [Field1=1] applied, I will only see the following in the code mapping sheet.
And if I create the primary group from the Name column, it would only contain those 3 names with 3 codes.
It is easily noticeable when I have a small data like this, but when I have a very big data set, it's not easy to see that this is happening.
So in order to avoid this problem, I have to get rid of all the global filters, create primary groups, and then put the global filters back to the sheets.
Along with my suggestion on automatically updating the primary groups when the secondary databases are updated, can you also take above into consideration and make changes please?
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...