Count (Max(Date))

[cbaqir]

I have an app in which I need to display the count of the current workflow status for distinct REQUEST_ID.

Each REQUEST_ID has multiple workflow steps.

To determine current workflow status, I am looking at max(WORKFLOW_STEP_ELIG_DATE) and then want a count of the associated WORKFLOW_STEP_NAME.

I started with:
=count(aggr(max(WORKFLOW_STEP_ELIG_DATE), REQUEST_ID))

And then tried applying the FirstSortedValue expression but it didn't work because I can't use nested aggregation to get the MAX ELIG_DATE:

=FirstSortedValue([WORKFLOW_STEP_NAME], (-Aggr(Count( DISTINCT WORKFLOW_STEP_ELIG_DATE), REQUEST_ID)))

Any guidance would be greatly appreciated. Thanks in advance!

Cassandra

[cbaqir]

Also, my intent is to produce a bar chart that shows Volume of Request_IDs by Current Workflow Step. If I use an aggr expression, is that limiting me to a static table of information?

[agomes1971]

Hi,

if your expression is not set analysis it is not static.

Regards

André Gomes