How can I find the earliest date a Jira changed status (preferably by a certain group of users)

[Brandon Toms]

Greetings, Jira friends!

I'm trying to create a custom structure board formula that returns the earliest date that someone in a group of users changed the status of a ticket.  Here's what I got so far:

history.changes.FILTER($.field = "status" AND (
 $.author.name = "Brandon"
 OR $.author.name = "Greg"
 OR $.author.name = "David"
)).MAP($.created).MIN():

However this doesn't work.  It seems that I can't get a date from a change item.  I was able to do something similar with comments that WAS successful:

comments.FILTER(
 $.author.name = "Brandon"
 OR $.author.name = "Greg"
 OR $.author.name = "David"
).MAP($.created).MIN():

Can someone help with this formula?

Thanks in advance! 

[Stepan Kholodov _Tempo_]

Hello @Brandon Toms 

You can try this formula:

history.changes.FILTER($.field = "status" and ($.changegroup.author = "Brandon" or
$.changegroup.author = "Greg" or $.changegroup.author = "David")).changegroup.time.min()

I hope this helps. If you need further assistance or help with anything else in Structure, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)