OTBI - Field to show max effective_start_date by action_code

Summary

In OTBI workforce assignments I'd like to show the max effective_start_date of assignment based on action_code

Content

Hi all,

While working on "Workforce Management - Worker Assignment Event Real Time" subject area, alongside other fields I want to be able to filter out the latest effective_start_date for a specific person, based on action_code field.

I was trying to use the following but with no success:

filter(max("Assignment Event Details"."Effective Start Date") using "Assignment Event Details"."Action Code" = 'some_code').

Thanks in advance!

Pavel

Version

18.b

Code Snippet

filter(max("Assignment Event Details"."Effective Start Date") using "Assignment Event Details"."Action Code" = 'some_code')