I would highlight the Label and Response fields and pivot them
Can't make 'pivot' work for the life of me.
It removes the 'response' data. I think I'm doing it correctly - Copy the fields - paste as data source - in the copy highlight both - select 'pivot'.
I wouldn't do the copy/paste/etc.... Simply highlight both fields and select pivot (without doing your extra steps in between)
Can you attach some dummy data for me to test ?
What sort of data file are you connecting to ?
What version of Tableau are you using ? (more along the lines of have you tried Tableau Prep to do this?)
I cannot highlight and pivot. Not sure why, but some reading earlier lead me to copy and paste, then I am able to - however it doesn't work as a normal pivot as I know in Excel.
My data is coming through like this: https://support.safetyculture.com/integrations/pull-safetyculture-audit-data-into-tableau/
I downloaded Tableau today - I have Tablea prep, but cannot make it work with the Web upload feature, so have not spent much time on it.
Let me get some dummy data together.
What are you trying to do ? I mean what is your final visualization should look like ? Based on that we can find a solution in tableau. We might not even need the labels in columns. can you provide the final output design you are looking for ?
Kalyan, Please see attached image.
Essentially, iAuditor data comes in grouped as per the top 'current' table. All Audit results that our staff complete, sit within the same column. I want to extract each of the parameters that our staff record into a column, so that they can be altered to 'numerical' fields etc. Without it, I am struggling to do anything super useful.
I have been able to do some nice things within the worksheet. It is just the data source that I am struggling to get right. See my second image. This shows what Ive been able to do within the worksheet to present the data nicer. I am happy to just continue along that track except that being unable to convert some of my measured parameters to a 'measure' is limiting me? Does that make sense?
Thanks for the assistance so quickly. Excited to get this sorted, as it will apply to all of my 10+ audits.
If you want your labels as measures, you can write calculations.
IF [Label] = "Cover Hook" THEN [Response] END
You can call the above field as "Cover Hook parameter" or any other suitable name. You can do the same kind of manipulations using this as well as you are doing with Response.
and just so you know, you cannot do pivot on all datasource. As far as i know, pivot only works on excel datasources.