To create table on jira dashboard

[prakhar mishra]

I need to create a table on a Jira dashboard with multiple rows and columns. For example, for FY23, there are 3 columns, each with different JQL queries. However, I can't find any gadgets that allow me to create a table. Could anyone help if they know how to do this?

[Danut M _StonikByte_]

Hi @prakhar mishra,

Could you please detail a bit what info do you want to display in that table, more exactly? Count of issues, sums, percentages, issues - what exactly do you need?

Anyway, if the Two Dimensional Filter Statistics of Jira is not helpful, then you could search for an app on Atlassian Marketplace that provides such gadget.

If you consider the idea of using an app, our Great Gadgets app offers two gadgets that could be helpful for you.

Pivot Table & Pivot Chart gadget - displays multi-dimensional stats (counts, sums, average, percentages etc) based on multiple fields of the issues from a filter/JQL.

Advanced Issue Filter Formula gadget - Calculates and displays the result of up to 6
math formulas applied to numeric fields of issues from up to 6 filters or JQLs.

Danut.

[Fabio Racobaldo _Herzum_]

Hi @prakhar mishra and welcome,

try to use Two dimensional filter gadget for this purpose

Hope this helps,

Fabio

[prakhar mishra]

Hi @Danut M _StonikByte_ 

I need to create a table with columns for FY23 and FY24. 

---

Under FY23, there will be 3 columns with 4 rows, named as follows:

1. Total issues (JQL: type = "BUG" AND createdDate >= "2022/11/01" AND createdDate < "2023/02/01")

2. Done (JQL)

3. NAB (JQL)

The rows will represent each quarter (Q1, Q2, Q3, and Q4), with the `createdDate` varying for each quarter.h

The same structure will be created for FY24 as well, with the appropriate `createdDate` ranges for each quarter.

[Danut M _StonikByte_]

Hi @prakhar mishra,

Thanks for these details.

By using the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app you can get a statistic like this which may suit your needs to a great extent. 

You can have two tables like this: one for FY2023, one for FY2024. Or, you can have them both in one gadget. 

The gadget can display quarters of createdDate but it supports only one filter. So to get this, you'll have to configure it with a filter that returns all the issues from FY2023 and then to get stats by Status or Status Category as in my example.

If you need any help or have more questions, feel free to contact us at support@stonikbyte.com  

Danut.