Select ongoing projects

[#1]

I have a source with two tables.

Tab1
Projectnr (ex 1,2,3)
Timemode (ex order, documentation)

Tab2
Activity (ex finished, started, changed)
Timemode

A Project can have diffrent milestones (activities),
Started, Finishied, posted, changed and so on.

I want to find a way to see which projects are ongoing, that doesnt have the milestone "Finished" and as a uniqe projectnumber.

[agomes1971]

Hi,

just have to add a column activity to your project table and then you'll have the relationship you want to see.

Regards

André Gomes

[jagan]

Hi,

What is the relation between Tab1 and Tab2?  There should be Projectnr in Tab2 or Activity in Tab1 then only you can join two tables.

Regards,

jagan.

[#4]

I have the column of activities but when you select activity "Started" for example I see all projects with this activity, but a project can have several activites "Finished" included,

And I only want to see the projects that doesnt have the activity "Finished"

For example:

Project 1 have the activites Started, Changed, Finished

Project 2 have the activites Started, Changed

[#5]

The relation is Timemode.

[jagan]

Hi,

How you join the two tables with Timemode since all projects will have time modes?  There should be Projectnr field in the tab2.

Can you attach sample file.

Regards,

Jagan.

[michael_anthony · Accepted solution]

A chart with project number as dimension and expression if(Sum (if Activity = 'Finished',1)> 0,0,1).  That should list projects without the finished activity.

[#8]

This gives me a column that shows 0 or 1 depending on the activity is Finished (0) or have an other status (1)

This helps alot, is there a way in the chart always only show the milestones with status 1?

[michael_anthony]

Make sure turn on zero suppression in the chart properties.