You have the following dataset.
You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?
To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user.
The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau. ISFULLNAME([Tableau_user]) = USERNAME() is not a valid expression in Tableau. 'S' + STR([Sales]/1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of ''S''. Reference: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields.htm
Carissa
1 months agoJanna
1 months agoPa
1 months agoRickie
20 days agoAretha
26 days agoLorrine
28 days agoViola
2 months agoQueen
2 months agoMicah
2 months agoKatina
2 months agoKathryn
10 days agoGaston
17 days agoRolande
23 days agoRima
27 days agoRozella
1 months agoKrissy
2 months agoJestine
2 months ago