Dashboard gadget that gets total tickets in a filter and displays custom text if it meets criteria

Question

I'm interested in getting a gadget for my dashboard that runs through a JQL query, gets the "total" results number and runs it through some logic to display text.

Example:

If query total results > 49 then display text "Over capacity. Do not assign more tickets."

If query total results < 50 then display text "Can accept more tickets."

I've considered writing some sort of script that'll pull on json data -- but I'm wondering if there's an easier way at this?

Stephanie Frantz · Answer

JIRA Software 7.4.4

We were hoping this to be a quick one-liner that would appear on a dashboard.

We don't need to see all of the issues, we just need a count and some human-readable text.

We have been doing it with some simple gadgets that show the filter -- and another simple text gadget that says "If the filter below is over 50, then do not assign any more tickets".... But something that is generated would be significantly more ideal.

Tom Lister_fo1j4e · Answer

Hi @Stephanie Frantz

which jira are are you using? Software? Service desk?

the effect you want sounds very like a software kanban board. You can set limits on number of issues in a column which will go red if over limit.

the purpose being to highlight that processes are over capacity.