How do I show a GAUGE report of a portfolio that shows the percent of projects that should be completed today verses the actual completed count? | Community
Skip to main content
C
cquick77
Level 3
June 21, 2021
Question

How do I show a GAUGE report of a portfolio that shows the percent of projects that should be completed today verses the actual completed count?

  • June 21, 2021
  • 1 reply
  • 545 views

How do I show a GAUGE report of a portfolio that shows the percent of projects that should be completed today verses the actual completed count? And it needs to change each day as more projects are due.

the count of actual completed or canceled projects "by today"

divided by

the count of projected completed projects "by today".

If the two numbers match exactly (100% or 1), I’d like the dial to point straight up at “On target”.

If we are ahead (101+% or >1), it will lean to the right toward “Ahead of Schedule”.

If it’s behind (99-% or <1), it will lean to the left toward “Behind Schedule”.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    kynabaker16
    Adobe Employee
    kynabaker16Adobe Employee
    Adobe Employee
    June 21, 2021

    For some reason this one made me think about @Linnie Ciepielowski‚ and her reporting prowess... Linnie, do you have any ideas here?

    L
    LinnieCi
    Level 4
    June 21, 2021

    This is a great question. There might be a more elegant solution than this, but my inclination would be to start by creating a dashboard with two project reports, one showing projected completion dates and the other showing actual completion dates for all projects in a given portfolio, using the "today" wildcard.

    Then you could compare the two manually. I'm not sure if there is a portfolio-level calculated field you could craft to analyze the projects within - I'd be interested to hear if anyone knows how to do this!

    Terms & ConditionsAccessibility statement

    Loading footer...