Don’t create a reference field for this. You can get first assignment group in a metric definition instead. We just did this some while back for reporting purpose.
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
