I'm new to Tableau and could use some help.
I have 2 data tables, first one simply has a list of all 50 US States (client locations).
Second table only has a list of those states where we are actively doing projects.
I'm trying to create a calculated field that will display next to the first table with all the states whether or not there is an active project in that state. I want to pull in the first table column that shows all 50 states and have a calculated column next to it that says "active project" or "no project"
I can't seem to figure out how to do this. Any input appreciated. It seems so simple but Tableau formulas are confusing to me.
Thanks a ton!!
@Melisa Dannhauser how did you join these two tables? Did you do a left join on these tables with matching fields like and Id or something? Can you share sample data file or .tbwx file that has these two tables to have a closer look? Once your do this join then you can create a calc field like
IF [Country] = [Country (Country2)] THEN "Active Project" ELSE "Inactive Projects" END
Left Join tables:
Just attaching a dummy .twbx file that might help.
