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.

Filtering of activities in P6

21 replies [Last post]
Kannan CP
User offline. Last seen 2 days 22 hours ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Hi Friends,

How to fiilter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month. Assume as a baaseline schedule

For eg:

Activity 1: Dec 2011 to Jan 2012

Act 2     : Feb 2012 to Sep 2012

Activity3: Apr 2012 to Oct 2012

Activity4: Nov 2012 to Dec 2012.

I want to filter and see the activities during the time period of Aug 2012. Activities 2 & 3 are passing through the Month Aug 2012.

I filtered both with Early start/Early finish & start/finish-with in the range of Aug 01 & 31. but its not working.

Can somebody advise me with a solution.

Thanks

Kannan

Replies

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

Meurig 

Glad I could help you

Meurig Davies
User offline. Last seen 4 years 19 weeks ago. Offline
Joined: 25 Jun 2008
Posts: 13

Thanks for you help Zoltan. Your solution works perfectly.

 

 

Regards,

 

Meurig

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

Meurig

if you only want to find passing thru Jan 2020 then

filter 

all

where Start is less than Jan 1 2020

and 

finish is greater than Jan 31, 2020

 

also if you want activities that happen during Jan 2020 you will need to use 2 filters 

use the 1st one I listed and add a 2nd filter

any 

where start within the range Jan 1 2010 (low value) and Jan 31  2020 (high value)

or where where finish within the range Jan 1 2010 (low value) and Jan 31  2020 (high value) 

 

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

Kannan

filter

ANY where

 

start is within the range (low value) 8/1/201 and 8/31/2012 (high value)

or finish is within the range (low value) 8/1/201 and 8/31/2012 (high value)

Meurig Davies
User offline. Last seen 4 years 19 weeks ago. Offline
Joined: 25 Jun 2008
Posts: 13

I am looking to pass through January when it will be planned to be in progress.

 

Regards,

 

Meurig

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

Meurng

You have to at lest tell me what month you are looking to pass through ?

I think you are looking for 

activity status  equals in-progress

this will list any activities that have started but are not yet done.

Meurig Davies
User offline. Last seen 4 years 19 weeks ago. Offline
Joined: 25 Jun 2008
Posts: 13

Hi All,

How to fiilter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month. 

eg:

All activities that fall within th date range 1st Jan to 31st Jan whether thay are planed to Start,Finish or pass through in Progress

 

Thanks in Advance

 

Meurig

Meurig Davies
User offline. Last seen 4 years 19 weeks ago. Offline
Joined: 25 Jun 2008
Posts: 13

Hi All,

How to fiilter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month. 

eg:

All activities that fall within th date range 1st Jan to 31st Jan whether thay are planed to Start,Finish or pass through in Progress

 

Thanks in Advance

Rafael Davila
User offline. Last seen 11 hours 12 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Robert, your solution is very good, as we say at home very much better!

BTW as far as I can recall MSP have such filter pre-defined under the name of Date Range Filter.

Robert Bell
User offline. Last seen 5 years 38 weeks ago. Offline
Joined: 8 Jun 2016
Posts: 49
Groups: None

It doesn't matter much, but a slightly quicker way to filter for a particular period is;

Where Start is less than 31-Aug-12

And Finish is Greater than 01-Aug-12

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

I posted the p6 answer

Rafael Davila
User offline. Last seen 11 hours 12 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

How to filter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month?

How in progress filter will find out if will be in progress a few months after Baseline DD?

In progress between Aug. 1, 2012  -  Aug. 31, 2012?

I am not a P6 user any longer but maybe the above can be specified, in such case it should be enough to make the filter.

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

I dont know what your data date is but here is a solution

solution #1

filter 

where

Paramenter       is                                   value                high value

start               is within the range of        aug 1, 2012       aug 31, 2012

or

Finish                is within the range of        aug 1, 2012       aug 31, 2012

or 

activity status              equals                     inprogress

 

 

Rafael Davila
User offline. Last seen 11 hours 12 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Learn to use the operators, any activity that complies with Condition 1 OR Condition 2 OR Condition 3 OR Condition 4 will make it.

==>> Do not use AND operator.

BTW as long ago I stopped using Primavera each day it passes it becomes more difficult to understand it.

Ramshad kuniyil
User offline. Last seen 6 years 31 weeks ago. Offline
Joined: 22 Aug 2017
Posts: 2
Groups: None

Hi rafael,

i want to filter the activities as condition 4 like you mentioned above. i did by puting start date greater than or equal to august 1 and finish date less than or equal to august 30. but its not showing all the activities. it is showing only finished activities. i need all activities within the range

 

 

best regards

Arneil Cagas
User offline. Last seen 9 years 36 weeks ago. Offline
Joined: 25 Apr 2014
Posts: 3
Groups: None

hi,kannan,

 

open ur project, go to group & sort,group by select start , and  select a Month if group interval

 

and then apply, ok.

 

vty/Arneil

dulat Praliyev
User offline. Last seen 4 years 9 weeks ago. Offline
Joined: 18 Apr 2011
Posts: 9
Groups: None

Hi

Can you explain how to working filter?

Kannan CP
User offline. Last seen 2 days 22 hours ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Thanks a lot Rafael, Ferdinand, Shareef.

Now its working.

Regards

Kannan

Shareef Abdul Azeez
User offline. Last seen 2 years 39 weeks ago. Offline
Joined: 19 Sep 2005
Posts: 183

841
1.jpg

This is how the Filter Coniditions given by Rafael would be in P6 and it works !!!

 

Regards

Shareef

Ferdinand U.
User offline. Last seen 6 years 30 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142

Rafael's reply is the answer to any filter lookahead date problem

 

for your situation, condition 3

 

Filter specs should be:

 

All of the following

Start is less than or equals 01-Aug-12

Finish is greater than or equals 31-Aug-12

Rafael Davila
User offline. Last seen 11 hours 12 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

I do not use P6 but the following set of conditions can be a way:

  • Condition 1: activities starting within the date range.
  • Condition 2: activities finishing within the date range.
  • Condition 3: activities starting before the date range and finishing after the date range.
  • Condition 4: activities starting and finishing within the date range,

Learn to use the operators, any activity that complies with Condition 1 OR Condtition 2 OR Condition 3 OR Condition 4 will make it.

Best regards,

Rafael