-
1. Re: Is there a way to give (All) an alias within a quick filter?
Shawn Wallwork Jun 15, 2012 7:54 AM (in response to Don Barnetson)Don, if only it were so! Not only can't you give it an alias, you also can't use the '(All)' in a field calculation, which would also be handy. If you write these up in the Idea section I'll give it a +1.
--Shawn
-
2. Re: Is there a way to give (All) an alias within a quick filter?
Joe Mako Jun 17, 2012 2:26 PM (in response to Don Barnetson)You could use a parameter instead and use a calculated field to apply the desired filter.
please provide a sample workbook if you would like to see an example.
-
3. Re: Is there a way to give (All) an alias within a quick filter?
Don Barnetson Jun 18, 2012 6:12 AM (in response to Joe Mako)Hi Joe,
I have created a very basic example. If you notice, I have only given $ values up to April (YTD, let's say). I have added a quick filter by month. If there is a way to have (All) on the quick filter represent YTD, so that the user understands that it is YTD and not the Total year.
Thanks,
Don
-
4. Re: Is there a way to give (All) an alias within a quick filter?
Joe Mako Jun 18, 2012 10:55 PM (in response to Don Barnetson)Can you please attach as a packaged workbook, .twbx? (no data is included in a a .twb file)
-
5. Re: Is there a way to give (All) an alias within a quick filter?
Don Barnetson Jun 19, 2012 5:10 AM (in response to Joe Mako)Thanks. Here it is.
-
6. Re: Is there a way to give (All) an alias within a quick filter?
Joe Mako Jun 19, 2012 4:23 PM (in response to Don Barnetson)1 of 1 people found this helpfulHow about the attached?
You can get fancier with checking the Month vs the month for TODAY() as well.
-
7. Re: Is there a way to give (All) an alias within a quick filter?
Shawn Wallwork Jun 19, 2012 4:36 PM (in response to Joe Mako)Joe, that works fine as long as you don't need to select multiple months. This is why we need to be able to give the (all) in a filter an alias. (But then you know that already.)
-
8. Re: Is there a way to give (All) an alias within a quick filter?
Joe Mako Jun 19, 2012 4:52 PM (in response to Shawn Wallwork)You are describing a different situation, and it has a different solution.
For this thread start, the question was to alias a single select quick filter on data that does not change, and one solution is to use a parameter. Waiting for Tableau to add the ability to alias the (All) option is another route, but does not help anyone today
If the data changes or you need a multi-select, then another possible solution (within the current constraints of Tableau), is to duplicate the data.
Take a look at the attached, be aware it does not make sense to select a"Total YTD" and the other months at the same time.
Are you noticing a pattern? If you have the ability to transform your data prior to Tableau (using custom SQL falls into this category, so does ETL), you can accomplish almost anything in Tableau.
-
9. Re: Is there a way to give (All) an alias within a quick filter?
Shawn Wallwork Jun 19, 2012 8:02 PM (in response to Joe Mako)Joe interesting solution, as usual. But I'll stick with the feature request Don posted in the Ideas section.
You and I look at these forums a bit differently, I think. A lot of the Tableau folks obviously monitor these forums, looking for feedback, and even ideas on ways to improve their product (I assume). While I'm happy to answer questions when I can, and provide work-a-rounds (in many cases things you taught me), ultimately I use these answers as ways of pointing out some of the places Tableau could make things better/easier, in the hope that someone is listening.
I guess it comes down to you are primarily trying to help someone today; I'm trying to help us all tomorrow. I really don't know that Tableau survives if it stays a 'programmer' driven tool where it takes a custom SQL join just to change the name of a filter option. I hope I'm wrong, I really enjoy working in this software. Anyway...
--Shawn
-
10. Re: Is there a way to give (All) an alias within a quick filter?
Don Barnetson Jun 20, 2012 6:19 AM (in response to Joe Mako)Thanks Joe. It works great! It's a bit of work, but it does the job.