Forum Discussion
How to control thermometer Legend Ranges by percent instead of fixed numbers
How to control thermometer Legend Ranges by percent instead of fixed numbers Since I have multi expected target numbers on my data set (table) pls. find below, I should be able to put Legend Ra...
Ex:
KPI Legend 1 : 0%-40% > Red Color
KPI Legend 2 : 41%-80% > Yallow Color
KPI Legend 3 : 80%-100% > Green Color
but the problem is i cannot add percent on value of legend range !!,
Kindly advice ?
| KPI | Target | Range(1)-40% of target |
| KPI 1 | 100 | 40 |
| KPI 1 | 100 | 40 |
| KPI 1 | 100 | 40 |
| KPI 2 | 380 | 152 |
| KPI 2 | 380 | 152 |
| KPI 2 | 380 | 152 |
| KPI 3 | 550 | 220 |
| KPI 3 | 550 | 220 |
| KPI 3 | 550 | 220 |
| KPI 4 | 30 | 12 |
| KPI 4 | 30 | 12 |
| KPI 4 | 30 | 12 |