COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: jsibley on 03 Sep 2026 03:57:35 PM

Title: Running Count off of a Rank
Post by: jsibley on 03 Sep 2026 03:57:35 PM
I have workflow set up for approvals.  One person can have multiple approvals span over different days.  I tried doing a running count like this running-count([Initiated Date] for [Employee Number]).  The result gives me a running count of all of the employee number ignoring the Initiated Date.

I switched it rank seems to count the numbers well.  The challenge is I want to have a running count based off a rank like this:
1   1
1   2
2   1
2   2
2   3

I switched the Auto group & summarize button on and off and it didn't help.  Any ideas?