Forum Discussion
Ramendra_k
May 23, 2024Copper Contributor
Wanted to know how to visualize compliance in case of more than 1 columns(Parameter) in Excel
Hi Sir,
Can you please help me to know how to get a better view for the table where I have 10 column names and each column have contains two values (Compliant and Non-Compliant).
I want to create a view where I can show the compliance percent of each column name (Parameter) in a single table or Pivot table by date or by week or by Month.
Below is raw data sample.
Incident NumberDateParameter1Parameter2Parameter3Parameter4Parameter5Parameter6
INC01 | 21-May-24 | Compliant | Compliant | Compliant | Compliant | Compliant | Compliant |
INC02 | 22-May-24 | Compliant | Non Compliant | Compliant | Compliant | Compliant | Non Compliant |
INC03 | 23-May-24 | Non Compliant | Non Compliant | Compliant | Compliant | Compliant | Non Compliant |
INC04 | 24-May-24 | Compliant | Compliant | Compliant | Compliant | Compliant | Compliant |