Is there consistent wording in the metadata? If so you may be able to use contains() to get a set of words that you could use on the color shelf:
if contains([your metadata],"Good") then "Good" elseif contains....
the metadata is just a number 1-10. My big question is:
1) How do I get this metadata into Tableau in the best way
2) How do I consume it/use it to achieve my goal of being able to overlay it on the data itself as color or filter etc
For example imagine I have three time series measures: Retail Sales, Auto Sales, Restaurant Sales
I have a separate field/table that contains a list that looks like this:
Retail Sales 8
Auto Sales 9
Restaurant Sales 4
How do I join this table to the time series data (by measure name presumably) so that I can reference it in calculated fields or color range?
I find this a very interesting question. I should like to know what you mean by "Data Reliability". Do you use it in the sense of measurement accuracy or measurement precision, or in the sense of reliability in the psychological test literature? Or perhaps in some entirely different sense?