-
1. Re: Create a conditional filter based on an action?
Stephen Rizzo Aug 26, 2016 12:27 PM (in response to chanah stern)I am guessing that there are multiple ways to implement this. One idea might be to create a table that to decode which hours should be shown for which hour of day. You could then create a regular action filter on that table to show what you want. See the attached workbook for an example.
-
Forums - hours.twbx 16.7 KB
-
-
2. Re: Create a conditional filter based on an action?
chanah stern Aug 29, 2016 7:14 AM (in response to Stephen Rizzo)Thanks so much for your response!
I am using Tableau 9.2 and am told that the file was created with a later version of Tableau and it cannot be opened. What version did you use to create it?
-
3. Re: Create a conditional filter based on an action?
Stephen Rizzo Aug 29, 2016 10:28 AM (in response to chanah stern)I used Tableau 10. You can recreate this workbook yourself using instructions below:
- Create new workbook sourcing data from the attached Excel file.
- Create two worksheets, the first worksheet with HOUR(Hour) in the rows shelf, the second with HOUR(Show hour) in the rows shelf.
- Create a new dashboard, adding both worksheets side-by-side
- Select the "Use as filter" icon for worksheet 1
Selecting any hour from worksheet 1 will show the appropriate hours in worksheet 2. You can easily extend the table to include all 24 hours.
I hope this helps!
-
sample2.xlsx 8.8 KB
-
4. Re: Create a conditional filter based on an action?
chanah stern Aug 29, 2016 10:50 AM (in response to Stephen Rizzo)Thanks very much! I will try that.
-
5. Re: Create a conditional filter based on an action?
chanah stern Aug 29, 2016 1:28 PM (in response to chanah stern)Hi Stephen,
I think I understand your approach now. Is there anyway for me to apply it in a scenario where my regular data is in a database and this mapping table is in an Excel file. So far I haven't found a way to join the two - is there some way to do it?
Thanks so much!
-
6. Re: Create a conditional filter based on an action?
Stephen Rizzo Aug 29, 2016 1:32 PM (in response to chanah stern)What are you using for a data source? If you have access to custom SQL, you could create that table using custom SQL code.
-
7. Re: Create a conditional filter based on an action?
chanah stern Aug 29, 2016 1:34 PM (in response to Stephen Rizzo)Great idea. Thanks! I'm on it....