Stephen,

Thanks for the response! I can't seem to open your Tableau workbook though - I'm getting the following error:

Unable to complete action

Errors occurred while trying to load the workbook "C:\Users\USERNAME\Downloads\LineChart.twbx". The load was not able to complete successfully.

Errors occurred while trying to load the workbook "C:\Users\USERNAME\Downloads\LineChart.twbx". The load was not able to complete successfully.

Error(284,66): no declaration found for element 'simple-id' (id: C:\Users\USERNAME\AppData\Local\Temp\TableauTemp\943152468\LineChart.twb)

Error(284,66): attribute 'uuid' is not declared for element 'simple-id' (id: C:\Users\USERNAME\AppData\Local\Temp\TableauTemp\943152468\LineChart.twb)

Error(285,14): element 'simple-id' is not allowed for content model '((cards,viewpoint?)|(viewpoints,active,device-preview))' (id: C:\Users\USERNAME\AppData\Local\Temp\TableauTemp\943152468\LineChart.twb)

Any idea why this might be happening?

Thanks, this version worked!

Two more things to iron out though:

1) I thought I followed what you did, but I now have three separate line graphs for "No", "Unknown", and "Yes" adjacent to each other. I have "Response" across the top of my three graphs. How do I combine them all into one line graph with just the compliance rates shown (as you have)?

2) For one of my metrics, the "Yes is compliant, No is non-compliant" values actually need to be flipped, because whoever designed this survey question before I started here wasn't thinking of the implications. Can I accommodate this with some sort of conditional statement, perhaps with a calculated field or similar?

Thank you for all the help! Could you just explain how to write the calculated field with conditional logic switching those values only for certain Metrics? I can't seem to find a good way to do it.

This makes sense, but it actually creates a problem with my Row calculation. I have:

SUM([Response Value]) / TOTAL (SUM([Response Value]))

This was working before I added the conditional logic as you described, but now I'm getting the following error:

The Table Calculation for _(the above)__ requires a field that is missing. Please add the missing field to the view.

For my conditional logic, I wrote out the following (given that there are two metrics needing to be flipped):

IF [Metric] = "ABC" AND [Response] = "YES"

THEN "NO"

ELSEIF [Metric] = "ABC" AND [Response] = "NO"

THEN  "YES"

ELSEIF [Metric] = "XYZ" AND [Response] = "YES"

THEN "NO"

ELSEIF [Metric] = "XYZ" AND [Response] = "NO" '

THEN "YES"

ELSE [Response]

END

Could there be an issue with my conditional logic, or do you think it's a problem with the table calculation used for the Rows?