-
1. Re: Switch parameters dynamically based on filter values
Hari Ankem Nov 11, 2017 6:34 PM (in response to Vasu choudhury)The list of values in a Parameter is static and cannot be controlled by another parameter or a filter. You can look at having another data source with the required values for a quarter, and joining your primary data source with it.
-
2. Re: Switch parameters dynamically based on filter values
Norbert MaijoorNov 15, 2017 10:11 AM (in response to Vasu choudhury)
Hi Vasu,
As mentioned by Hari Ankem you are not able to "populate" a parameter dynamically
An approach could be based on scaffolding in combination with "Relevant Values Only"...but no sure if this is feasible in your scenario. For sure you need a place where you can define the relation between Qtr and Status
Then you are able to work with "cascading" filters based in "Only Relevant Values"-functionality
Hope it helps
Regards,
Norbert
-
3. Re: Switch parameters dynamically based on filter values
Vasu choudhury Nov 12, 2017 5:52 PM (in response to Norbert Maijoor)Thanks for your reply Hari & Norbert!
I don't think this could be a feasible solution in my scenario because I do COUNTD(ID) and derive the parameter values based on the below logic.
Currently dsplaying the Parameter as a quick filter in the dashboard along with other Qtr field.
Created calc field and set to 1 in Filter shelf.
Case [parameter]
when ‘1’ then ‘1’ <--- All Status
when ‘2’ then if [ELIG]=1 and [ENC]=0 then 1 end <-----Eligible
when ‘3’ then if [ELIG] = 1 and [ENC]=1 then 1 end <---- Encounter
end
Please let me know if there is any work around.
-
4. Re: Switch parameters dynamically based on filter values
Peter Fakan Nov 12, 2017 8:16 PM (in response to Vasu choudhury)Hi Vasu,
You could try grouping the different arrangements of status fields and then using these groups from your calculated field that you build off your parameter;
in pseudocode
case [parameter]
when "1" then [group 1]
when "2" then [group 2]
else [group 3]
end
HTH
Peter
-
5. Re: Switch parameters dynamically based on filter values
Vasu choudhury Nov 13, 2017 2:02 PM (in response to Peter Fakan)Hi Peter,
I think i cannot group based on multiple field values. Please find the attached workbook for your reference.
Dashboard 1: By default i should see all these values(parameter 1) and is working as expected.
Dashboard 2: Expected results. When selected 2015-Q3, then it should display 2 values or trigger(2015-Q3 parm)
Which means that when 2015-Q3 is selected, then 2015-Q3 parm should be placed instead of parameter 1.
And this should happen in one dashboard.
Highly appreciated for any other work around.
-- Vasu.
-
Paramter_Values.twbx 288.9 KB
-
-
6. Re: Switch parameters dynamically based on filter values
Vasu choudhury Nov 15, 2017 8:32 AM (in response to Vasu choudhury)Hello Experts,
Could you please let me know if any one has any other work around in addressing this functionality.
Regards,
Vasu.
-
7. Re: Switch parameters dynamically based on filter values
Norbert MaijoorNov 15, 2017 10:11 AM (in response to Vasu choudhury)
I would like to ask my fellow ambassador Shinichiro Murakami to the table.
Shinichiro Murakami Could you think of an alternative approach on the directions already provided above.
Once again thanks for your valuable input.
Regards,
Norbert
-
8. Re: Switch parameters dynamically based on filter values
Shinichiro MurakamiNov 15, 2017 11:06 AM (in response to Norbert Maijoor)
I only know ridiculous approach on these request.
Change the field "Dummy" from "XXXXXX" to " " when you use.
I keep it "XXXX" to show the design background
Thanks,
Shin
-
Paramter_Values_SM_10.3.twbx 310.9 KB
-
-
9. Re: Switch parameters dynamically based on filter values
Norbert MaijoorNov 15, 2017 11:52 AM (in response to Shinichiro Murakami)
-
10. Re: Switch parameters dynamically based on filter values
Shinichiro MurakamiNov 15, 2017 12:42 PM (in response to Shinichiro Murakami)
Here is some explanations.
Re: Hiding a parameter control when an action filter is triggered
Thanks,
Shin
-
11. Re: Switch parameters dynamically based on filter values
Vasu choudhury Nov 16, 2017 3:04 PM (in response to Shinichiro Murakami)Hello Shin,
That's a good work around to tell the story in a different way.(Business expectation is that to show in a single parameter based on Date/QTR selection which can't be done in Tableau)
However the values from Parameter1 are not driving to the Sheets 3&4 where as other parameter(2015-Q3 parm) does it.
Could you please help me in driving the Parm1 values to other sheets without breaking the other Param selections when selected.
Thanks,
Vasu.
-
13. Re: Switch parameters dynamically based on filter values
Vasu choudhury Nov 16, 2017 8:17 PM (in response to Shinichiro Murakami)Sure Shin, will mark it correct answer if the issue is resolved.
If we change 2015-Q3 param to Parameter 1, other parm selection values are breaking out.
i.e. Select 2015-Q3(Quarter of Order Date). Displays same data in sheet 3&4 for both values(Eligible, Non-Eligible) selected in 2015-Q3 param.
Note: Sheet 3&4 should drive by Quarter of Order Date , 2015-Q3 param & Parameter 1.
Thanks,
Vasu.
-
14. Re: Switch parameters dynamically based on filter values
Shinichiro MurakamiNov 16, 2017 10:53 PM (in response to Vasu choudhury)
-
Paramter_Values_SM_10.3_v2.twbx 310.7 KB
-