Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Filter projects in EPS by milestone status

3 replies [Last post]
Will Radford
User offline. Last seen 7 years 51 weeks ago. Offline
Joined: 31 Aug 2015
Posts: 6
Groups: None

I (as well as my company) am new to running P6, and have what should be a basic question.  I have searched the internet and have come up empty.  What I want to know is if I can filter projects in the EPS window based on milestone status.  Now I know the first thing you might say is that milestones are unique for each project and so how could you filter all your projects based on milestones that could be anything?  Correct, that wouldn't work, but if you did have a standard set of milestones that were used in each project, you should be able to filter all your projects based on whether or not the milestones have been completed.  

For example, (1) Drafting inititated, (2) Drafting 50% complete, (3) Drafting 90% complete, (4) Drawing issued for construction.  If all my projects used these four milestones then I should be able to filter projects in the EPS screen on them.  Like, show me all projects that have drafting 90% complete, but not issued for construction.  

If this functionality is flat out unavailable, I would love to hear other ways you all do similar types of filtering and reporting.

Thanks.

Replies

Johannes Vandenberg
User offline. Last seen 5 weeks 5 days ago. Offline
Joined: 21 Jan 2010
Posts: 234

Hi Will

You can filter all milestones for all projects under the same EPS as follows.

  • Select and open all projects in the same EPS
  • Go to filter and select "milestones

I consider using milestones for progress reporting on drawings is not the most efficient method. I understand that you would be interested in the status of the progress attained for the drafting of drawings over all the projects in the EPS. The most effective method is to use "steps". In steps you can make an global template  with the percentage say

  1. Step 1 15%
  2. Step 2 50%
  3. Step 3 90%
  4. Step 4 100%

Then you can use filter as desired.

Trust this helps

Johannes

Zoltan Palffy
User offline. Last seen 3 days 6 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

you could create a portfolio and part of the filter for the portfolio would be your filter parameters

Akhtar Khan
User offline. Last seen 2 years 3 hours ago. Offline
Joined: 22 Jan 2008
Posts: 9

You can do this only in activity window, open all projects-apply filter-you can view progress of all open project milestones in one window.