Forum Discussion

Ramendra_k's avatar
Ramendra_k
Copper Contributor
May 23, 2024

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

Resources