Structure how to count number of changes to a field

[Mauro Bennici]

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

[Valerie Knapp]

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

[Stepan Kholodov _Tempo_]

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)

[Mauro Bennici]

thanks! It works!

[Saurabh Kejriwal]

Works like a charm. many thanks Stepan and Mauro

[Veronica Ibragimova]

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

[Stepan Kholodov _Tempo_]

@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