CODEWITHSUNDEEP
parameterstableau-apiautomatic-properties
Hertel89
Hertel89

Reputation: 23

Tableau automatic parameter / calculated field

I am very new to Tableau, and I am strugling a bit. I have a data set of measurements from an automated process looking similar to this:

| UNC with intial data | ... | Measurement Start | UNC with data with headers | Invalid row in the end|

UNC : Unknown number of columns which may very from different data set

What I want to do is to make 6 subsets of graph where the x axis is set, but the data for the Y-axis is taken from a list generated by the data columns and their headers. Similar to this: http://kb.tableau.com/articles/knowledgebase/parameterized-measure - just with the measures created automatically.

Is this possible in anyway?

EDIT: I'll try to specify my question:

What I want is an parameter and calculated field, that allows for me to easily view all measures in the data set that ends with _meas in their name. Meaning, I have a standarized dashboard that views the measures accross a set of standard values (Supply voltage, frequency, dutcycle etc.) and a dropdown list that allows me to change the measures. I would like that the parameter and calculated field was created automatically, and not something I have to hard-code every time I change a measures name or the number of measures I have imported.

Upvotes: 0

Views: 5233

Answers (1)

Inox
Inox

Reputation: 2275

I'm guessing that what you want is to select an item in a dropdown list, which represents a measure, and plot that measure in different charts.

If that is the case, it is pretty simple. You already have the dropdown list, using a parameter, TestNames.

Now, create a calculated field, named Measure, and do it like this:

CASE [TestNames]
WHEN 'Measure A' THEN [Measure A]
...
END

This way, Measure will actually get the value of the measure you select in the list

Upvotes: 1

Related Questions