FirstSortedValue(MESSAGE_TYPE,-Max( if(HAS_ERRORS=True,0, if(MESSAGE_TYPE='NOT_IMPORTANT',0, [MESSAGE_DATE] )) )) as LAST_USEFULL_MESSAGE_TYPE
Resident [MESSAGES] Group by OPERATION_ID;
But it throws an error due to the FirstSortedValue/Max: "Nested aggregation not allowed"
Now, I'm thinking in creating an additional column to mark/rank the LAST_USEFULL_MESSAGE in order to pick the LAST_USEFULL_MESSAGE_TYPE. But perhaps it's too complicated and there is an easier way to have the bar chart working.
How could I show the amount of operations (use cases) in ther current progress status?