How to graph a checklist

Question

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 graph which of the processes has the most failures "X" and also which day has the most failures"X", im a newbie and couldnt find a post related to this, thanks if anyone can help

DAY	1.1	1.2	1.3	1.4	1.5	1.6	1.7
MONDAY	V	V	V	V	X	X	V
TUESDAY	V	V	V	X	V	V	V
WEDNESDAY	X	V	V	X	V	X	V
THURSDAY	X	V	V	X	V	V	V
FRIDAY	V	V	X	X	V	V	V
SATURDAY	V	V	V	V	V	X	V

alexisolson · Accepted Answer

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

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

Forum Discussion

How to graph a checklist

2 Replies

Related content

Fabric graph

Creating Cumulative Graphs

Graph view

Imitate a checklist in PowerBI

Azure resource graph and KQL