Forum Discussion

Ivan9485's avatar
Ivan9485
Frequent Visitor
4 years ago
Solved

How to graph a checklist

I'm doing a checklist where "V" means that the process (1.1,1.2,...) was completed correctly, while "X" means that it failed, the checklist is made everyday from Monday to Saturday and i need to grap...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    If you unpivot the process, and transform V/X into 0/1 so that your data table looks like this:

     

    Then it's simple to drop these columns into a matrix visual with subtotals showing failure counts across the dimensions.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Ivan9485 ,

Has your problem solved by AlexisOlson 's solution? If yes, please consider accept it as the solution to help the other members find it more quickly. If not, please feel free to let me know.

Best Regards,
Community Support Team _ kalyj