Cathal McConnell Posted January 20, 2021 Share Posted January 20, 2021 I have a table like so: Project Task Completion P1 Scheduling 20/01/2021 P1 Filing 19/01/2021 P2 Admin P2 Safety 19/01/2021 In this table Project P1 is complete, as both tasks have completion dates. P2 is not complete as only one task has a completion date. I want to create a KPI that shows the number of completed projects, which in this case would be 1. ie. Show the number of projects with 100% completion. Any help would be greatly appreciated. Thanks in advance. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted January 21, 2021 Share Posted January 21, 2021 Try this. Calculate column [incomplete] as: case when [Completion] is null then [Project] end The value of KPI is: UniqueCount([Project]) - UniqueCount([incomplete]) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now