Structure how to count number of changes to a field

greetings,

I am using history on structure, and I am trying to count the occurrences of a field's history but I get some issues.

using a simple

history.changes
.FILTER($.field = "Status")

I get all the status changes in the field:

Status -> to do, Status -> in progress etc.

I need to count the number of changes, but if I simply wrap the formula in a COUNT it gives weird results (i.e. 3 status changes but the count says 10).

How can I fix it?

thanks

3 answers

1 accepted

Suggest an answer

2 votes

Answer accepted

Hi @Mauro Bennici , thanks for your question.

You can also reach out directly to the vendor of Structure, who should be experts on how the product works - Structure by Tempo - Jira Portfolio Management & PPM | Atlassian Marketplace

Hope this helps.

Cheers

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello @Mauro Bennici

The COUNT aggregate function indeed won't work here - such functions can only aggregate data from multiple items in the structure - e.g. counting the number of or the sum of Story Points of all child issues etc.

In your case, you need to count the number of transitions in a single issue in the same field. This formula should do it:

history.changes.FILTER($.field = "Status").size()

I hope this helps. If you need further assistance, please reach out to us directly at our support portal.

Best regards,
Stepan Kholodov
Tempo (The Structure app vendor)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

thanks! It works!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

Works like a charm. many thanks Stepan and Mauro

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

1 vote

How can I use this Formula if I want to take into account changes only when the issue was in specific statuses?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Veronica Ibragimova

You can count only specific transitions with a formula like this:

history.changes.FILTER($.field = "Status" and $.to = "status name").size()

If you have more questions about formulas or Structure in general, please reach out to us directly at our portal.

Best regards,
Stepan

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

0 votes

How would you show the date of the specific status that an issue was updated to? The formula below doesn't show any errors. However, the column is blank once rendered.

Values{ history.changes.FILTER($.field = "Status" and $.to = "Approved").MAP($.date) }

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Nicole Walsh hi, the formula should be:

values{history.changes.FILTER($.field = "Status" and $.to = "Approved").changegroup.time}

Best regards,
Stepan

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • John Funk likes this

Was this helpful?

Thanks!

App Central

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Structure how to count number of changes to a field

3 answers

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Atlassian Community Events