CODEWITHSUNDEEP
tableau-api
Chris
Chris

Reputation: 343

How do I filter by more than one measure

I have a Word Cloud visual. The size of my words are determined by my total number of employees. Employees is its own field. Two other fields are FTE and Contract and they add up to my total employees. I want to filter my visual by either FTE or Contract. But when I drag these Measures under Filters and uncheck one, it results in no data displaying.

My Visual

My Data

Upvotes: 0

Views: 99

Answers (1)

tyvich
tyvich

Reputation: 580

From your excel snapshot, it looks like you have a column for FTE and Contract. Since all records have a value for each column, if you "uncheck" one of them. All record will be filtered out.

From your question it appears you are trying to size the words based upon the number in either FTE or Contract (not total employees)? If this is the case, I would recommend creating a separate calculated field that toggles between the two fields based on a parameter value.

Ex. Calculated Field 1

IF [parameter] = "FTE" 
THEN [FTE] 
ELSEIF [parameter] = "Contract"
THEN [Contract]
ELSEIF [parameter] = "Total Employees'
THEN [Total Employees]
END

Ex. Parameter (String), List

Value              Display As
FTE                FTE
Contract           Contract
Total Employees    Total Employees

Upvotes: 1

Related Questions