Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Test case results

Rafa_B
6 - Meteoroid

Hi,
I need to create a report for test case result, like a pivot table, from several excel files.
Until now I've able to join all the excel files and sheets, and I have a table like this:

 

 

AreaProcessCaseStep#Test DateCompany 1Company 2Company 3
SpareMaster DataMMR-DM0112017-10-23OKOKOK
SpareMaster DataMMR-DM0212017-10-23NOKNOKNOK
SpareMaster DataMMR-DM031    
SpareMaster DataMMR-DM0412017-10-23N/AN/AOK
SpareMaster DataMMR-DM0512017-10-23N/AN/AOK
SpareMaster DataMMR-DM0612017-10-23NOKNOKNOK
SpareMaster DataMMR-DM0712017-10-23N/AN/AOK
SpareMaster DataMMR-DM0812017-10-23N/AN/AOK
SpareMaster DataMMR-DM0912017-10-23N/AN/AOK
SpareMaster DataMMR-DM101    
SpareMaster DataMMR-DM1112017-10-23OKN/AN/A
SpareMaster DataMMR-DM112    
SpareMaster DataMMR-DM1212017-10-23OKN/AN/A
SpareMaster DataMMR-DM121    
SpareMaster DataMMR-DM1312017-10-23OKN/AN/A
SpareMaster DataMMR-DM1412017-10-23OKOKOK
SpareMaster DataMMR-DM1512017-10-23OKOKOK
SpareMaster DataMMR-DM1612017-10-23OKN/AN/A
SpareMaster DataMMR-DM1712017-10-23  NOK
SpareMaster DataMMR-DM1812017-10-23N/AOKN/A
FPMaster DataFP-DM0112017-10-23OKN/ANOK
FPMaster DataFP-DM0112017-10-23N/AOKOK

 

I need to count all cases result for all companies except for N/A values, empty values meaning test pending.
The desired output would be:

 

AreaProcessCasesTestedPendingOKNOK%OK%NOK
SpareMaster Data40261419747,5%17,5%
FPMaster Data4403175,0%25,0%


How could I achieve this scenario?
Any idea is wellcome.

4 REPLIES 4
JoshKushner
12 - Quasar

You can create the desired output by transposing the data and joining a series of filters and summarizations.

I've attached a sample workflow.

 

Flow:

Flow.PNG

 

Result:

Result.PNG

 

Transpose:

Transpose.PNG

 

Formulas:

Calculate Percentages.PNG

 

jrgo
14 - Magnetar

Hi @Rafa_B,

 

Here's a possible solution based off your example tables. Workflow attached.

 

2017-10-26_11-22-25.jpg

 

Hope this help!

 

Best,

 

Jimmy

 

 

danrh
13 - Pulsar

Give this a try:

image.png

Hope it helps!

Rafa_B
6 - Meteoroid

Jimmy, thanks for your solution!

Also thanks to Josh and Danrh, I've tested all your ideas. 

Labels