
1. Re: Percentage of Data Showing
Dan Cory May 8, 2018 3:55 PM (in response to Julia Cobb)Attached is one version of this. I used the current version of Tableau 2018.1 since you didn't say if you were using an older one.
The basic idea is to create a calculation like:
{EXCLUDE State: SUM([Sales])}/({FIXED:SUM([Sales])})
where State is your dimension and [Sales] is your measure.
The numerator (using EXCLUDE) will obey the filter, while the denominator (using FIXED) will ignore the filter.
Dan

Fraction Shown.twbx 347.7 KB


2. Re: Percentage of Data Showing
Julia Cobb May 8, 2018 4:07 PM (in response to Dan Cory)Thank you, Dan. Unfortunately I'm on 10.5.3, so i can't open the workbook. I tried winging it using the formula you put and it's not wanting to work. it's giving me a range and the max percentage I can get is ~24%. Do you have the ability to put the book in an older version? If not, i'll have to update. Thanks again

3. Re: Percentage of Data Showing
Dan Cory May 8, 2018 4:09 PM (in response to Julia Cobb)Here you go!
Dan

Fraction Shown_v10.5.twbx 352.0 KB


4. Re: Percentage of Data Showing
Julia Cobb May 8, 2018 4:51 PM (in response to Dan Cory)Thanks Dan. It's still not wanting to work for me. I have multiple dimensions so I added those in to the Exclude as well. I also have multiple axes, but that doesn't seem to have any effect on the workbook you sent over. It just says "All" until about 8% is showing, then it shows the percentage until about 6% then it says "None". My chart is a network graph, so maybe the relationships are screwing it up. Oh well. I'm just going to calculate it in excel and keep the column hard coded. Thank you for your help.