Hello Folks,
I have a basket of KPIs that my company is using. What I'd like to do is store the target/warning/alert values in some sort of spreadsheet. What I'm getting hung up on is how to structure such a spreadsheet.
Right now I've got something like this.
| Location | Metric | Target | TimePeriod |
| CHUCKECHEESE | Popcorn Pay | $100 | Weekly |
But I also want to show the user Green/Yellow/Red coloring, which transforms my chart into this.
| Location | Metric | Target | YellowPct | RedPct | TimePeriod |
| CHUCKECHEESE | Popcorn Pay | $100 | 120 | 150 | Weekly |
This is workable if the value is between the Target/Yellow/Red. But if it is on one side of the Target or Red, then we need to know which direction is "good".
So now my chart is:
| Location | Metric | KPIDirection | Target | YellowPct | RedPct | TimePeriod |
| CHUCKECHEESE | Popcorn Pay | MIN | $100 | 120 | 150 | Weekly |
| CHUCKECHEESE | Mouse Revenues | MAX | $250 | 80 | 60 | Weekly |
As you can see, my KPI Target document is getting out of hand. I was wondering how other people solve this problem, or if I'm just going to have to have lots and lots of columns. A simple template would go far in helping me materialize my vision.
Any help is greatly appreciated.
