Cookie Consent by Free Privacy Policy Generator

The Best Of

Go to the Best Of the SEO Community.

Noah
Noah
Jan 19, 2025, 10:15 AM
Forwarded from another channel:
Forwarded thread from another channel:
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 and no patience to figure it out yet....this report I put together is just a complete fckn mess now
Shawn Huber
Shawn Huber
Jan 15, 2025, 9:18 AM
I think that should say 97% to goal meaning 3% short
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
Shawn Huber
Shawn Huber
Jan 15, 2025, 9:20 AM
So (233,978 divided by 239,394) -1
Shawn Huber
Shawn Huber
Jan 15, 2025, 9:20 AM
That’ll give you the MoM increase or decrease
Grace
Grace
Jan 15, 2025, 9:21 AM
yeah it calculates correctly when I remove the progress bar thing
Grace
Grace
Jan 15, 2025, 9:21 AM
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.
Shawn Huber
Shawn Huber
Jan 15, 2025, 9:24 AM
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! I have to simplify this report now and get it back "online" then I'll come back to this

Our Values

What we believe in

Building friendships

Kindness

Giving

Elevating others

Creating Signal

Discussing ideas respectfully

What has no home here

Diminishing others

Gatekeeping

Taking without giving back

Spamming others

Arguing

Selling links and guest posts


Sign up for our Newsletter

Join our mailing list for updates

By signing up, you agree to our Privacy Policy and Terms of Service. We may send you occasional newsletters and promotional emails about our products and services. You can opt-out at any time.

Apply now to join our amazing community.

Powered by MODXModx Logo
the blazing fast + secure open source CMS.