I have been wracking my brain on setting up a relatively simple 3 month report, but I cant seem to wrap my head around it.
I am looking to put, what i assumed to be, a very simple graph on a dashboard to our Leadership team:
I want to, in columns basically show the next 3 months - How many Projects are expected to start up, how many are running and how many are expected to complete.
I am kinda imagining a stacked column, greens for projects starting, grey for projects neither starting nor ending, red for projects completing.
I hope there is some simple trick I am not seeing, outside of exporting data to Excel or Power-BI.
Cheers
-Stefan
Topics help categorize Community content and increase your ability to discover relevant content.
Hi Stefan,
One way to handle this without having to resort to Excel or Power-BI would be as follows:
Optionally, you could include only Projects with values of "Starting", "Completing" or "Running" in your report. You could also refine the Leadership Assessment even further (e.g. On Hold, Running Late, etc.) to be more precise. And you might want to consider using Projected Dates rather than Planned Dates, as doing so might better represent when things are projected to happen, rather than were planned to happen.
And finally, to ensure the data stays current, I'd recommend you periodically refresh the calculations periodically either manually, or using either our Recalc Helper or Recalc Parameters solutions.
I'm interested to hear how you make out -- good luck!
Regards,
Doug
----------------------------------
IF(ISBLANK(Actual Completion Date)
,IF(Planned Start Date > $$TODAY
, IF(Planned Start Date < $$TODAY+3m
,"Starting"
,IF(Planned Completion Date > $$TODAY
,IF(Planned Start Date < $$TODAY+3m
, "Completing"
,"Running"
)"Running"
)
)
,IF(Planned Completion Date > $$TODAY
,IF(Planned Start Date < $$TODAY+3m
, "Completing"
,"Running"
)"Running"
)
)
,"Completed"
)
Views
Replies
Total Likes