Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Jira Two Dimensional Charts - Cannot display resolutiondate / resolved in either X or Y Axis

Michael Green June 23, 2022

Hi,

In Confluence I'm trying to use a Jira Filter to display a table of the last 7 days of Service Management closed tickets..... by date and by Request type (a custom field).

I can get the custom field to be on Y axis but I cannot get the resolutiondate / resolved field on either the X or Y Axis.

Why can't the resolution date be used ?

 

project = IDYOUS AND STATUS = Resolved AND resolutiondate >= -7d AND "Service Desk Customer Type[Dropdown]" != XYZ ORDER BY KEY ASC

 

Here is a mock up of what I'm trying to achieve:

 

 

Support Request x

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Total

 

20/06/2022

21/06/2022

22/06/2022

23/06/2022

24/06/2022

25/06/2022

 

Password reset

4

5

4

5

  

18

Set Up New account

10

6

10

12

  

38

How to use IDyou

4

     

4

Video call – Connection issues

1

     

1

Video Call - Activate Camera/microphone

 

1

    

1

Edit Account details

3

     

3

Code not received

 

1

1

   

2

Edit Details of VOI

      

 

Login/Access Issue

      

 

Still Waiting on Docs after uploading

      

 

White Screen/Blank screen

      

 

Data/Face mismatch errors

      

 

Issues with VOI report/processing

1

 

1

   

2

Types of documents to be used

  

1

   

1

Still trying to using App

      

 

Sales Queries

1

  

1

  

2

Validity of VOI report

      

 

Emails from borrowers to IDyou Inbox

  

3

   

3

Concerned about spam

      

 

Total

24

13

20

18

 

 

75

2 answers

2 votes
Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 24, 2022

Hi @Michael Green ,

If your company uses our Table Filter and Charts for Confluence app, you may try a workaround using its Pivot Table macro and the standard Jira Issues macro.

You'll be able to show issues with dates in a tabular form coming from the Jira Issues macro and aggregate them against different time periods using the Pivot Table macro.

Maybe this will help your case.

Michael Green July 14, 2022

Hi @Charles.Chaaya another one for your backlog...

2 votes
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 23, 2022

@Michael Green -

Hi Michael:

Unfortunately, currently the gadget only support the following data types fields for the x/y axis -

Group picker
Multi select
User picker
Select list
Version picker

There is an open enhancement request - https://jira.atlassian.com/browse/JRACLOUD-37545.  Please note although this case is for Pie-chart gadget, but it is also for other out the box gadgets (including the gadget you mentioned). 

Your only other solution will be to research for 3rd party add-on that provide more enhanced/robust gadgets in the Marketplace for JSM Cloud.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

NORBERTUS WUSANA February 22, 2023

Hello, same issue and difficulties. Is there any other options to show chart based on field: "date" on our x y axis? 

Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 22, 2023

@NORBERTUS WUSANA -

Unfortunately, it is not possible using the out of the box gadget because Date field is not supported currently.

Best, Joseph

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events