Pivot data by desired columns

Question

Hello

Would it be possible to achieve pivot solution like that? So I have data normalized and can easily create Pie Chart in Tableau. I would very much appreciate the help.

So the pivot by Steps Passed, Failed, Skipped, Pending, Undefined:

#FeatureStepsPassedStepsFailedStepsSkippedStepsPendingStepsUndefinedStepsTotalScenariosPassedScenariosFailedScenariosTotalFeaturesDurationFeaturesStatusAT Job NameTest cases for Matching8000081012.843PassedQS_Test_Automation_ITVTTest cases for Standardization6000061013.277PassedQS_Test_Automation_ITVT

It pivots by Steps Values:

Pivot Field NamePivot Field ValueStepsTotal#FeatureFeaturesDurationFeaturesStatusAT Job NameStepsPassed88Test cases for Matching2.843PassedQS_Test_Automation_ITVTStepsPassed66Test cases for Standardization3.277PassedQS_Test_Automation_ITVTStepsFailed08Test cases for Matching2.843PassedQS_Test_Automation_ITVTStepsFailed06Test cases for Standardization3.277PassedQS_Test_Automation_ITVTStepsSkipped08Test cases for Matching2.843PassedQS_Test_Automation_ITVTStepsSkipped06Test cases for Standardization3.277PassedQS_Test_Automation_ITVTStepsPending08Test cases for Matching2.843PassedQS_Test_Automation_ITVTStepsPending06Test cases for Standardization3.277PassedQS_Test_Automation_ITVTStepsUndefined08Test cases for Matching2.843PassedQS_Test_Automation_ITVTStepsUndefined06Test cases for Standardization3.277PassedQS_Test_Automation_ITVT

mborriero · Accepted Answer

Hi @dlesny,

Yes, it is possible. You would need to use two select tool, in one you can select the field feature and the other that you want to pivot, instead the other select will keep the other information.

Then, you can pivot the field that you like and join back the other on the field feature.

FInd my solution attached, I hope it works.