How to represent Number field on a dashboard

[CEDRIC DEVAUX]

Hi community,

I create an automation to calculate the amount of business days between 2 dates.

Now I want to represent number of tickets per the amount of days in a gadaget dashboard something like this (I made a drawing below to explain what I would like to represent)

Is there a way to display a number field on gadget as another customfield?

Thank you 

[CEDRIC DEVAUX · Accepted solution]

Hi @Tanya _DevAcrobats_  & @Trudy Claspill 

That's what I thought, that there wasn't a native gadget.

I can use filter result with different range of amount

ex: 1st filter number of tickets where diff time < 10 days

2nd filter number of tickets where diff time >= 10 days & < 20days

...

Thank you both for your help.  :)

[Tanya _DevAcrobats_]

Hello, @CEDRIC DEVAUX ,

One option you may try is Performance Objectives app developed by our team. The app comes with 10 dashboard gadgets to create a variety of interactive reports and charts for SLA, Time in status, Time tracking, trends & more KPIs, with standard and custom metrics.

You can  represent the number of tickets per amount of days with the app using your custom number field.

You can also achieve this without additional custom field and without automation, by utilizing the 'Time between' metric available in the app to get the time between 2 dates (in days, hours, minutes) and applying a user-defined work calendar to take into account only business days/hours.

The app supports the concept of using number fields as metric and breaking metric data by user-defined distribution ranges.

Here is an example of your requirement on a pie chart configured with Circular Chart Dashboard gadget, you can also choose donut chart with this gadget. If you prefer to display the data on a bar chart, you may try Performance Objectives gadget.

You can also add 2 more dimensions to the report (fields or metrics), e.g. 'Issue type' as Level 2 and 'Priority' as level 3. Here is an example of pivot view with 3 Level Circular chart:



Our support will be glad to help if you decide to try the app and need help with the configuration.

Tanya

[Trudy Claspill]

Hello @CEDRIC DEVAUX 

The Pie chart and Two Dimensional gadgets you show can only be based on fields that have a selection list of defined values. They cannot group based on a field that does not have a pre-defined set of possible values.

You could use the Filter Counts gadget to display counts of issues based on filters. You would have to construct a filter for each possible value for your custom field.

There isn't a native gadget for what you want to do.

You might be able to do that with third party apps that add more gadgets to the Dashboard options.

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=custom%20charts