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

[TABLE="class: grid, width: 30, align: center"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]TICKET NO[/TD]
[TD]INIT RESP SLA MET[/TD]
[TD]RESOLUTION TIME SLA MET[/TD]
[TD]PRIORITY[/TD]
[TD]SUPPORT COVERAGE[/TD]
[TD]MONTH[/TD]
[TD]DAY[/TD]
[TD]YEAR[/TD]
[TD]CREATION TIME[/TD]
[TD]FIRST UPDATE TIME[/TD]
[TD]CLOSE TIME[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]111[/TD]
[TD]TRUE
[/TD]
[TD]TRUE[/TD]
[TD]MED[/TD]
[TD]PEAK[/TD]
[TD]SEPT[/TD]
[TD]2[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]122[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]MED[/TD]
[TD]OFF PEAK[/TD]
[TD]SEPT[/TD]
[TD]3[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]231[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]MED[/TD]
[TD]PEAK[/TD]
[TD]SEPT[/TD]
[TD]6[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]178[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]HIGH[/TD]
[TD]PEAK
[/TD]
[TD]SEPT[/TD]
[TD]11[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]155[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]LOW[/TD]
[TD]PEAK
[/TD]
[TD]SEPT[/TD]
[TD]15[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]197[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]LOW[/TD]
[TD]PEAK
[/TD]
[TD]SEPT[/TD]
[TD]12[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]110[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]HIGH[/TD]
[TD]OFF PEAK[/TD]
[TD]AUG[/TD]
[TD]1[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]711[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]MED[/TD]
[TD]PEAK[/TD]
[TD]AUG[/TD]
[TD]4[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]233[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]MED[/TD]
[TD]PEAK[/TD]
[TD]AUG[/TD]
[TD]7[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]254[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]MED[/TD]
[TD]PEAK[/TD]
[TD]AUG[/TD]
[TD]23[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]478[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]MED[/TD]
[TD]PEAK[/TD]
[TD]AUG[/TD]
[TD]21[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]677[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]MED[/TD]
[TD]PEAK[/TD]
[TD]AUG[/TD]
[TD]1[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]205[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]LOW[/TD]
[TD]PEAK[/TD]
[TD]AUG[/TD]
[TD]2[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]555[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]HIGH[/TD]
[TD]PEAK[/TD]
[TD]AUG[/TD]
[TD]21[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]761[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]HIGH[/TD]
[TD]PEAK[/TD]
[TD]SEPT[/TD]
[TD]24[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]810[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]MED[/TD]
[TD]PEAK[/TD]
[TD]SEPT[/TD]
[TD]9[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


SHEET DASHBOARD

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]RESPONSE TIME[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]MONTH[/TD]
[TD]HIGH[/TD]
[TD]MED[/TD]
[TD]LOW[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]AUG[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]OFF-PEAK[/TD]
[TD]100%[/TD]
[TD]100%[/TD]
[TD]100%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]PEAK[/TD]
[TD]100%[/TD]
[TD]80%[/TD]
[TD]100%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]SEPT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]OFF-PEAK[/TD]
[TD]100%[/TD]
[TD]30%[/TD]
[TD]100%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]PEAK[/TD]
[TD]100%[/TD]
[TD]100%[/TD]
[TD]100%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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?