Run calculation on the dashboard to determine priority

[Prerak Parikh]

Hi Experts

I have a requirement to run the following calculation in the dashboard to determine priority:
priority = importance x frequency

On incidents, I've a drop down field that categorises incidents in 1 of total 15 categories available. Let's say the categories are A, B, C, D, E, F, I, J, K, L, M, N, and O.

My requirement is to associate each of these categories to an importance value from 1 to 10. For e.g., A's importance value is 5, B's value is 7, C's value is 10, and so on..

The dashboard gives me the frequency (or the count) of each of the categories. For e.g., 
A = 20, B = 13, C=23 and so on..

However, I need to have a dashboard that also does the following, and sorts the output in the descending order. The sort order requirement is not mandatory.

| Category | Importance | Frequency | Priority |

|-----------|--------------|-------------|---------|

| O | 10 | 80 | 800 |

| C | 10 | 23 | 230 |

| A | 5 | 20 | 100 |

| D | 8 | 12 | 96 |

| B | 7 | 13 | 91 |

| L | 7 | 10 | 70 |

| M | 6 | 10 | 60 |

| N | 5 | 9 | 45 |

| E | 3 | 12 | 36 |

| F | 5 | 3 | 15 |

| G | 4 | 2 | 8 |

| I | 4 | 2 | 8 |

| H | 3 | 1 | 3 |

| K | 3 | 1 | 3 |

| J | 2 | 1 | 2 |

[Jack Brickey]

Hi @Prerak Parikh , there is nothing native in Jira that would meet this requirement. You will need to check possible add on solutions or consider exporting to excel/sheets and leverage built n spreadsheet functions.