I've tried the CASE function, which I found under the support page http://onlinehelp.tableausoftware.com/current/pro/online/en-us/functions_functions_logical.html
The examples used double quotes.
CASE [Response] WHEN “Poor” THEN 1 WHEN “Fair” THEN 2 WHEN “Neutral” THEN 3 WHEN “Good” THEN 4 WHEN “Excellet” THEN 5 ELSE 6 END
But get the following error: ERROR IN CALCULATION, BAD CHARACTER, WOULD YOU LIKE TO CORRECT THE CALCULATION?
The first quote is highlighted indicating the bad character: CASE [Response] WHEN “Poor”
When I click that I want to correct, I see that the example uses single quote.
I changed to single quotes and this worked.
OK, still working from the excellent resource
Trying to get my data to look like this with the my COLUMNs in order with the count-distinct first: CNTD(UID) AVG(INSTRUCTOR-LICKERT1), as in image below.
But, not matter how I try my COLUMN lists the AVG before the CNTD, and I can't figure out how to reverse the order.
Arg, please help, thanks.
Leslie, did you type out the formula in another application or just copy it over? Because at least for the display of the formula as you posted it I'm seeing smart quotes (quotes that angle in towards the text), whereas Tableau requires regular double quotes or single quotes for strings.
Also on the forums we like people to use separate posts for different questions, as you ultimately did, thanks for doing that!