Need Help with Scorecard: 97% in Red Doesn't Add Up

The Best Of

Grace

Jan 15, 2025, 9:17 AM

i want to cry....I set up this scorecard and it seemed to be working fine but this 97% in red makes no sense. so far this month 233K is the number and the correct comparison figure is 239K Dec 1 to 14 so it's only down 2%

What am I missing here?!

Shawn Huber

Jan 15, 2025, 9:18 AM

The maths aren’t mathing. What is calculating that MoM?

Grace

Jan 15, 2025, 9:18 AM

I have no idea yet....

Shawn Huber

Jan 15, 2025, 9:18 AM

I think that should say 97% to goal meaning 3% short

Grace

Jan 15, 2025, 9:19 AM

OHHHHH

Shawn Huber

Jan 15, 2025, 9:19 AM

You aren’t doing a comparison calc.

Grace

Jan 15, 2025, 9:19 AM

ok I just don't know how to use the progress feature that well!

Grace

Jan 15, 2025, 9:19 AM

I have it set for comparison as well so I assumed

Shawn Huber

Jan 15, 2025, 9:19 AM

That is current data / previous data - 1

So (233,978 divided by 239,394) -1

That’ll give you the MoM increase or decrease in percentage

Grace

Jan 15, 2025, 9:21 AM

yeah it calculates correctly when I remove the progress bar thing. I thought it had been working correctly (as I thought it would) with progress bar

Shawn Huber

Jan 15, 2025, 9:24 AM

Progress is tracking towards a goal and shows what percent you are towards it. Not the same as difference.

Shawn Huber

Jan 15, 2025, 9:28 AM

You could create a second visual of that one and have both difference and progress.

you would need to add a square shape what has the same background color and then use the send to back/send to front function to layer the first KPI, then square shape and then second KPI where the shape hides most of the data minus the progress bar.

Shawn Huber

Jan 15, 2025, 9:30 AM

quick and dirty example of this

Grace

Jan 15, 2025, 9:31 AM

TY so much!