Want a formula or PIVOT to get the percentage of SLA met from True or False criteria

[ryanjuzz]

Hi Folks,

Need two options for this guys. If Pivot how can I configure the sheet raw to populate on sheet Dashboard percentage base on the TRUE and FALSE details from SHEET Raw

Second approach if pivot will be hard formula I can use on Sheet DB to give me percentage

SHEET RAW

1

A

B

C

D

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

2

TICKET NO

INIT RESP SLA MET

RESOLUTION TIME SLA MET

PRIORITY

SUPPORT COVERAGE

MONTH

DAY

YEAR

CREATION TIME

FIRST UPDATE TIME

CLOSE TIME

3

111

TRUE

TRUE

MED

PEAK

SEPT

2

2019

4

122

TRUE

TRUE

MED

OFF PEAK

SEPT

3

2019

5

231

TRUE

FALSE

MED

PEAK

SEPT

6

2019

6

178

TRUE

TRUE

HIGH

PEAK

SEPT

11

2019

7

155

TRUE

TRUE

LOW

PEAK

SEPT

15

2019

8

197

TRUE

TRUE

LOW

PEAK

SEPT

12

2019

9

110

TRUE

TRUE

HIGH

OFF PEAK

AUG

1

2019

10

711

FALSE

TRUE

MED

PEAK

AUG

4

2019

11

233

TRUE

TRUE

MED

PEAK

AUG

7

2019

12

254

TRUE

TRUE

MED

PEAK

AUG

23

2019

13

478

TRUE

TRUE

MED

PEAK

AUG

21

2019

14

677

TRUE

TRUE

MED

PEAK

AUG

1

2019

15

205

TRUE

TRUE

LOW

PEAK

AUG

2

2019

16

555

TRUE

TRUE

HIGH

PEAK

AUG

21

2019

17

761

TRUE

TRUE

HIGH

PEAK

SEPT

24

2019

18

810

TRUE

TRUE

MED

PEAK

SEPT

9

2019

<tbody>
</tbody>

SHEET DASHBOARD

	RESPONSE TIME
	A	B	C	D	E	F
1	MONTH	HIGH	MED	LOW
2	AUG
3	OFF-PEAK	100%	100%	100%
4	PEAK	100%	80%	100%
5	SEPT
6	OFF-PEAK	100%	30%	100%
7	PEAK	100%	100%	100%

<tbody>
</tbody>

 

[baitmaster]

Noting that your data appears to have a hidden column E, does the following formula help, in Dashboard B3?

=COUNTIFS(Raw!$F:$F,$A3,Raw!$D:$D,B$1,Raw!$G:$G,$A$2,Raw!$C:$C,TRUE)/COUNTIFS(Raw!$F:$F,$A3,Raw!$D:$D,B$1,Raw!$G:$G,$A$2)

in some circumstances you'll get a #div/0! error so you should amend the formula to handle a zero divisor, so the following is better (I split it out for clarity)

=IF(COUNTIFS(Raw!$F$2:$F$17,$A3,Raw!$D$2:$D$17,B$1,Raw!$G$2:$G$17,$A$2)=0,0,COUNTIFS(Raw!$F$2:$F$17,$A3,Raw!$D$2:$D$17,B$1,Raw!$G$2:$G$17,$A$2,Raw!$C$2:$C$17,TRUE)/COUNTIFS(Raw!$F$2:$F$17,$A3,Raw!$D$2:$D$17,B$1,Raw!$G$2:$G$17,$A$2))

 

[ryanjuzz]

Noting that your data appears to have a hidden column E, does the following formula help, in Dashboard B3?

=COUNTIFS(Raw!$F:$F,$A3,Raw!$D:$D,B$1,Raw!$G:$G,$A$2,Raw!$C:$C,TRUE)/COUNTIFS(Raw!$F:$F,$A3,Raw!$D:$D,B$1,Raw!$G:$G,$A$2)

in some circumstances you'll get a #div/0! error so you should amend the formula to handle a zero divisor, so the following is better (I split it out for clarity)

=IF(COUNTIFS(Raw!$F$2:$F$17,$A3,Raw!$D$2:$D$17,B$1,Raw!$G$2:$G$17,$A$2)=0,0,COUNTIFS(Raw!$F$2:$F$17,$A3,Raw!$D$2:$D$17,B$1,Raw!$G$2:$G$17,$A$2,Raw!$C$2:$C$17,TRUE)/COUNTIFS(Raw!$F$2:$F$17,$A3,Raw!$D$2:$D$17,B$1,Raw!$G$2:$G$17,$A$2))

----

Sorry for the late response and thank you @baitmaster for the reply. Sorry no specific on column E just missed it hehehe.

Anyway what are you referring to RAW? is this formula itself?