Please see the attached workbook for one possible solution.
The key here is to make use of the ZN function, which returns a zero when a NULL is found. Bring in your fields from the secondary data sources into the primary individually, and then use the ZN function on the new primary field.
Hope that helps,
Samplewb4.twbx.zip 743.1 KB
Thanks. Ok, does the GOAL_MET_PROFIT from the secondary data source have to be brought over to the primary for the Nulls to be eliminated, or can this be done right in the secondary data source with out brining it over to the primary?
I'm still learning tableau and going through the forums for interesting questions to help me learn about the things I'm no doubt going to run into at a later stage. I'm not sure what it means to bring one field into another but I did have a solution that I think works at least part of the way but then I get an issue with something completely different.
I've used ATTR to resolve the NULLs. I've named the calculated field Goal_Met_My_Try.
I needed to repeat some of the calculation in the the totals so I've created a new field for that with a name of My_Try as well.
Then I can get a graph to show you per state what the total goals met is, but I cannot get it to count distinct states, so it doesn't want to do a graph as you described.
Does that help?
My Try.zip 1.5 MB
Robin - Is there a way on your Sheet 3 tab (Counts by State) to show a solid bar in the graphs instead of the bars showing like they are with lines between each distinct count?