-
1. Re: Counting Total of All Options in a Filter
Ben NevilleNov 15, 2017 10:57 AM (in response to Kimberly O'Brien)
Your problem is that you have Line of Business as a dimension in your view. This means that Tableau is drawing a bunch of the same state polygons on top of each other.
To prove this, right-click New York, click Exclude, and underneath you will find you still have a New York polygon underneath, however the Line of Business label will be different. Just remove the Line of business from your view and you should have your problem solved.
-
2. Re: Counting Total of All Options in a Filter
Kimberly O'Brien Nov 15, 2017 1:33 PM (in response to Ben Neville) -
3. Re: Counting Total of All Options in a Filter
Ben NevilleNov 16, 2017 12:34 PM (in response to Kimberly O'Brien)
Very difficult to say without a workbook and some real or sample data.
If the values are smaller, it's either a join not functioning as you'd expect, a filter in place which is filtering out more values than you want, or an improper aggregation.
-
4. Re: Counting Total of All Options in a Filter
Kimberly O'Brien Nov 16, 2017 12:45 PM (in response to Ben Neville)Hi Ben,
I have the workbook attached.
Thank you for your help!
-
P&C Ancillary Lines.twbx 7.8 MB
-
-
5. Re: Counting Total of All Options in a Filter
Ben NevilleNov 16, 2017 1:05 PM (in response to Kimberly O'Brien)
2 things - first, you have a filter on Line of Business (copy) you need to remove this. You should then see in the lower left at the very bottom of the application, your correct value of 58,319
Second, you have 2,287 rows with a null state value. Tableau can't map them as it doesn't know where they should be included. To prove this (using the sample workbook you included):
- Remove Line of Business from text. You should now see something which says "1 unknown" in the bottom right of your map. Click this.
- Select Edit Locations...
- Click the text which reads "Unrecognized" and type "Alaska"
- Hover over your map and click the pin to zoom out. You should see these values have been mapped to Alaska, as well as the quantity of the rows.
This is obviously not the fix here, more I just wanted to show you where these "ghost" rows were going.