Reporting active projects for year over year comparison | Community
Skip to main content
Level 3
April 5, 2019
Question

Reporting active projects for year over year comparison

  • April 5, 2019
  • 2 replies
  • 696 views
Hi there, Is there a way to report how many active projects there were on any given day or month in order to compare year over year how many active projects we currently have vs. the year prior? Background: Last year we had roughly 75 projects active in the queue at any given time and now we have roughly 150 active projects in the queue at any given time. I would like to pull a report that reflects that. Thank you, Andrilita Rodriguez Mattress Firm, Inc.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Level 10
April 6, 2019
really the best bet would be to report on the project's entry date. At least it would give you the number of projects created at on any given day which you could aggregate to week, month, or year and YOY. -skye
Level 3
April 16, 2019
Hi Skye, Thank you for the suggestion. I have a similar report for new requests/projects that come, but it doesn't fully combine the projects that are already active at a given time to show the real full volume in the queue on any given day since each project can have a drastically different duration and may be in the queue for longer than others. Andrilita Rodriguez Mattress Firm, Inc.