How do I pull a retroactive report to see how many projects were still open at the end of each quarter? | Community
Skip to main content
M
MollyFr-1
Level 2
June 3, 2021
Question

How do I pull a retroactive report to see how many projects were still open at the end of each quarter?

  • June 3, 2021
  • 2 replies
  • 613 views

I would like to see the number above for each quarter of 2019 and 2020, then I would like to see this number for each month of 2021.

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

    2 replies

    J
    JanelleHi
    Level 4
    October 20, 2021

    Hi- I'd love this as well- has anyone figured this out? Thanks!

    SamanthaIsin
    SamanthaIsin
    Level 7
    October 20, 2021

    I've been working on an answer for this for awhile and the only way I've figured out how to achieve this is to utilize baselines. However, if you didn't have baselines set up when you want to pull your data (EX: 2019) then you can't pull the data.

    The best practice is to start using baselines now. I personally have been trying to figure out how to utilize Fusion to generate weekly, monthly, and quarterly baselines automatically. Haven't gotten it yet, but working on it!

    Terms & ConditionsAccessibility statement

    Loading footer...