Calculate flag based on grouping

Hi

I am trying to create a classification flag based on the task types completed by a contractor on a project on a daily basis.

A contractor may have multiple task types per day,

• if all daily task types are the same the flag will be the task type
• if the daily task types are different the flag will need to be different

With this flag I then want to create a matrix visual

I have attached the sample data set, aggregated data result and the required matrix here

Any help would be appreciated