I have added a tableau extract file. Can you mock up what you were trying to do in the prior example. The metric category has only 2 metrics? I figured for each channel there would be multiple options for each channel.
AlexKapFile.twbx.zip 22.2 KB
Don't worry about the metric category. It is something I wont be using. The fields that I was referring to are "Channel" and then you have the measures for each one which are "Served Impressions", "Clicks", "Total Conversions", "Dwell Time" depending on the "Channel" the user chose.
The final outcome should e the user choosing the channel -drop down menu, then the metric - drop down menu depending on the channel he previously chose and he gets the Chart he wants. (I have created a calculated field that I drop into the Rows that changes depending on the metric the user chose).
Ok if the user selects Channel "Display" what measure is suppose to display? and again for "Paid Search" and "Rich Media Display"?
Display should only have Clicks, Impressions, Conversions
Paid Search the same
Rich Media should have all the above and dwell time.
I see what you are saying now. I will have to have a think about it. I originally thought you were trying to work this with 2 dimension. I think there is an Idea out to be able to filter on Measure Names in a parameter. I am sure this can be done but I will need to come back to it later, hopefully someone else can help you has more advanced skills
Anyways take your time. I appreciate your help and maybe as you said someone could help me out.
If we dont catch up today have a great weekend.
What i understood by your problem is:-
1) if you want only relevant values in your filter then in filter properties choose "Only Relevant Values" will provide you the values related to your previous filter.
2) If you want to change the dimensions dynamically according to your filter then create a parameter. i am attaching a file which is having method to solve this problem.
Hope this will help!
AlexKapFile.twbx.zip 23.1 KB
Thank you for replying Prashant.
Your first solution isn't applicable because we are using parameters as filters. so the drop down list within the parameter is something fixed and not dynamic.
As for your second it is not what I am looking for.
I am trying to have a parameter filter that changes the drop down menu depending on what the user chose in the Master parameter filter.
anyways I really appreciate your help and time spent.
Wow... although this doesn't solve my initial problem, it does help me out with another issue I had.
The thing is I don't fully understand what you have done in order to adjust it to my data set.
If it of no big trouble could you walk me through the procedure (maybe even involve some screen shots) as I am a really new user of Tableau.
I would like to thank you personally for your time spent, and it seems that the Tableau community is a very helpful one.
Actually firstly i created a parameter in which i select string & put 'year', 'month' & 'Quarter'. After that i created a calculated field with the help of case statement
when 'Year' then DATENAME('year', [Date])
when 'Month' then DATENAME('month',[Date])+" "+DATENAME('year', [Date])
when 'Quarter' then 'Q'+""+DATENAME('quarter',[Date])+" "+DATENAME('year', [Date])
& put that calculate field in filter & this is what i done.
With this you can change your data too. I do that on some sample data. Manage according to that.
Yes Prashant I use this concept a lot for creating date ranges etc. I actually embed the parameter into the date function (you need to make sure the parameter uses the lower case for the value and have the Display as Proper for display:
Else " "+DATENAME('year', [Date])
But I have used for creating an average over a period of time (DATEADD) or to adjust by a number of periods as a parameter, really useful.
Unfortunately the abc Measures Names Dimension or # Measures Values Measure is not something that can be seen in the list of available fields when creating a calculated field.. .