I have a source with two tables.
Projectnr (ex 1,2,3)
Timemode (ex order, documentation)
Activity (ex finished, started, changed)
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.
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"
Project 1 have the activites Started, Changed, Finished
Project 2 have the activites Started, Changed
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?