Hey everyone,
i have few kpis that have different predefined targets each year..
i want to know what is the best method to have different target for KPIs every year..
Example:
KPI = 300 days
Targets for each year:
| Year: 2017 | 2018 | 2019 | 2020 | 2021 |
| Target: 730 days | 180 days | 90 days | 45 days | 20 days |
KPI = 80%
Targets for each year:
| Year: 2017 | 2018 | 2019 | 2020 | 2021 |
| Target: 70% | 77% | 85% | 89% | 91% |
Currently i can only use 1 target in the color expression...
