Flagged for impediment

[1234John4321]

Our team uses the flagged field to call out points of problems. 

I would like to track that information in an analytics dashboard. 
1. list of work items that are flagged

2. how long they have been flagged

Is this possible?

[Robert · Accepted solution]

Hey @1234John4321 

You should be able to pull the list of work items that are flagged using the issue or issue_custom_fields tables from the Jira product schema. 

How long they were flagged may take a bit more work, but should be possible using the Issue History table to query the time the field changed and comparing it against the issue creation time. 

Hope thie helps!