Skip to main content

Looking for help from someone with creating a drop down dynamic parameter for color.  I also wanted to create a filter by the same dynamic parameter, so I can then filter by color. The issue is that I am trying to place both string measures and float measures either under one parameter, so the user can choose what measure they can use as color.  I have seen a few similar requests that seem to come close to what I want:

 

Who Says Parameters Aren’t Dynamic? | THE MARKS CARD

Use Parameters to Make Views More Interactive

null

Filtering Multiple Dimensions Using Parameters | Tableau Software

Creating a Dynamic “Parameter” with a Tableau Data Blend | Drawing with Numbers

However, they are only just for dimensions, just for float measures, or just for strings.  All of them suggest created a parameter then calculated field.  I did that as suggested; however, I keep getting the "expecting float" or "expecting string" error.  Can anyone help?

 

(See the sheet labeled "Test")

 

Message was edited by: Mike Lane.   I uploaded a new version of .twbx to help clarify my question.

3 risposte
  1. 21 feb 2017, 01:29

    Mike,

    Whenever you use IF or Case statement, they can't be mixed, (just like in your case). So, they should be either string or numbers, but not both. However, if you convert ESI to string with STR() function, then you should be able to use 'Change Color' dimension. Looks like you deleted you new updated workbook as I don't see it now. Hope it helps.