Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,294,124
Community Members
 
Community Events
165
Community Groups

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

Edited

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

@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.

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

254 views 0 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you