Janson Ribeiro Posted June 14, 2022 Share Posted June 14, 2022 i would like to show the name of the process that has the most amount of delayed status how would i show the name of the process B, which has the most amount of delayed statuses, in a text field Process Status B DELAYED B DELAYED B DELEYAD B DELEYAD B DELEYAD A FINISHED A FINISHED Link to comment Share on other sites More sharing options...
Kevin Flynn Posted June 14, 2022 Share Posted June 14, 2022 Calculated Column (DelayedCountTotal): Sum(If ([status] = 'DELAYED',1,0)) OVER [Process] You can use that column to get the top 1. Link to comment Share on other sites More sharing options...
Kevin Flynn Posted June 14, 2022 Share Posted June 14, 2022 Just made something real quick. Should help. 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