Cookie Consent by Free Privacy Policy Generator

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

Go to the Best Of the SEO Community.

Grace
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
Shawn Huber
Jan 15, 2025, 9:18 AM
The maths aren’t mathing. What is calculating that MoM?
Grace
Grace
Jan 15, 2025, 9:18 AM
I have no idea yet....
Shawn Huber
Shawn Huber
Jan 15, 2025, 9:18 AM
I think that should say 97% to goal meaning 3% short
Grace
Grace
Jan 15, 2025, 9:19 AM
OHHHHH
Shawn Huber
Shawn Huber
Jan 15, 2025, 9:19 AM
You aren’t doing a comparison calc.
Grace
Grace
Jan 15, 2025, 9:19 AM
ok I just don't know how to use the progress feature that well!
Grace
Grace
Jan 15, 2025, 9:19 AM
I have it set for comparison as well so I assumed
Shawn Huber
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
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
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
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
Shawn Huber
Jan 15, 2025, 9:30 AM
quick and dirty example of this
Grace
Grace
Jan 15, 2025, 9:31 AM
TY so much! 

Channels

  • agency (3)
  • ai-for-seo (11)
  • ai-llms (24)
  • analytics (13)
  • biz-of-seo (4)
  • career (4)
  • content (15)
  • cro (4)
  • data-viz-reporting (4)
  • datascience (2)
  • ecommerce (3)
  • events (1)
  • freelance (2)
  • general-seo (21)
  • in-house (2)
  • local-seo (12)
  • local-seo,biz-of-seo (1)
  • lounge (1)
  • reading-list-resources (3)
  • search-console (11)
  • shameless-plug (1)
  • technical-seo (37)
  • tools (1)


    • Join The Community

    The SEO Community is a free organization, with private Slack group and events, for those interested in search and AI optimization to learn, discuss, and meet others in the industry.

    Powered by MODX

    Resources

    The Community Story SEO Articles SEO Jobs SEO Conferences Top SEO Discussions Newsletter Free Tools Learn Claude Code

    The SEO Community © 2026

    Shop Merch Code of Conduct Partnerships Sitemap Update cookies preferences Terms of Service Privacy Policy