nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Structure how to count number of changes to a field

Mauro Bennici_xlzhfl

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

Accepted answers

Valerie Knapp_dpp5c6

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

All comments

Valerie Knapp_dpp5c6

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

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_xlzhfl

thanks! It works!

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

@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

Saurabh Kejriwal

Works like a charm. many thanks Stepan and Mauro

Nicole Walsh

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) }

Stepan Kholodov

@Nicole Walsh hi, the formula should be:

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

Best regards,
Stepan

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

structure

addon-com.almworks.jira.structure