-
1. Re: Adding all to parameter filter
Michel Caissie Dec 17, 2013 1:51 PM (in response to Kim Cataldo)I didn`t fully validate but you could try to replace your parameter filter with
if [Select County & COC] = [County (copy)] then 'True'
elseif [Select County & COC] = 'All' then 'True'
end
If you select a specific County, the first line will catch it , and if you select All , since you don`t compare with any [County] the SUM(Value) will apply for all.
Michel
-
2. Re: Re: Adding all to parameter filter
Kim Cataldo Dec 18, 2013 12:49 PM (in response to Michel Caissie)Thanks for taking a look Michel.
I created a calculated field (Parameter All) with the formula you mentioned and added it to the filter shelf. I don't want to replace the other calculated field that references the parameter so that I do not disturb the functionality I already set up. The 'all' on the filter does not work, I am thinking I might not be able to have both functions.
-
Civil Dashboard - posting.twbx 620.4 KB
-
-
3. Re: Adding all to parameter filter
Mark Cook Dec 18, 2013 2:13 PM (in response to Kim Cataldo)Hello, Kim, since you are using a list, and there is no value in the list that is "All", you need a wildcard of sorts. I've dug around a bit in the community, and found http://community.tableau.com/thread/119626. There's got to be a way to continue working the parameter and calculated field idea to get the result you want.
-
4. Re: Re: Re: Adding all to parameter filter
Michel Caissie Dec 18, 2013 2:42 PM (in response to Kim Cataldo)Kim,
If i have red carefully, i would have seen that the complication was actually with the %Cases over 2 years worksheet.
I didn't fully understand all the logic between the calculation 4 and calculation 2 and Class to keep, but i made some changes in the Class to keep and calculation 2. It doesn't work completely but it may give you some hint on how to pursue
On the two other worksheets i made the changes i mentioned in the previous post. Here is the result, but i am not sure if it is exactly what you are looking for.
-
5. Re: Adding all to parameter filter
Kim Cataldo Dec 19, 2013 12:10 PM (in response to Michel Caissie)Thank you Michel! The integration of the two sets of formula was just what I needed. Appreciate your help!