Hi Amit,
thanks for the artical which you shared, i will use this option for straight fit metrics.
however, below is my requirement.
Hi...I am having 30 different Metrics with 30 different targets. For Ex: P1 sla 98%, P2 Sla 96%, P3 sla 94% & P4 sla 90%. Sometimes, few months are missing the targets. So now, the requirement is, if we missed any targets then we should highlight the same in red color.
For common targets, I can apply conditional formatting but I'm not able to apply conditional formatting option for different metrics with differnt targets.
We will be projecting the metrics in row wise formate as mentioned below.
Kindly help me how to do conditional formatting for different targets.
| SLA Metrics | Nov’19 | Dec’19 | Jan’20 | Feb’20 |
| Quality of User Experience (>90%) | 96.30% | 96.50% | 94.49% | 94.72% |
| Quality of User Experience (>75%) | 73.15% | 81.82% | 77.95% | 70.15% |
| Reactive - INC Response (P1) - 95% | 100.00% | 100.00% | 100.00% | 94.12% |
| Reactive - INC Response (P2) - 95% | 100.00% | 99.04% | 98.20% | 99.22% |
| Reactive - INC Response (P3) - 95% | 98.28% | 100.00% | 98.32% | 100.00% |
| Reactive - INC Response (P4) - 95% | 100.00% | 100.00% | 100.00% | 99.67% |
| Reactive - INC Restoration (Met1 - P1) - 90% | 100.00% | 50.00% | 84.62% | 88.24% |
| Reactive - INC Restoration (Met2 - P1) - 100% | 100.00% | 50.00% | 84.62% | 100.00% |
| Reactive - INC Restoration (Met1 - P2) - 92% | 97.64% | 95.19% | 93.69% | 97.66% |
| Reactive - INC Restoration (Met2 - P2) - 95% | 97.64% | 95.19% | 93.69% | 99.22% |
| Reactive - INC Restoration (P3) - 92% | 96.55% | 88.50% | 97.48% | 95.95% |
| Reactive - INC Restoration (P4) - 92% | 99.40% | 98.61% | 99.66% | 99.02% |
| Prod App - SAP (99.4%) | 100% | 99.99% | 100% | 99.88% |
| Prod App - SKYPE (99.4%) | 100% | 100% | 100% | 100% |
| WAN Availability - Unmanaged link (99%) | 96.20% | 95.55% | 98.32% | 97.76% |
| Tools Availability - SCOM (99%) | 100% | 100% | 100% | 100% |
Thanks,
Saranya
