Is it possible to create a dashboard with multiple logics?

[Ankit Yadav]

Hi Team,

We want to create a dashboard where we can get the following information:

• The number of bugs created in the months (for e.g. 1st Aug'23 to 31st Aug'23)
• Bugs closed (including backlogs) in the months (for e.g. 1st Aug'23 to 31st Aug'23)
• Data categorized by stage and criticality

I would really appreciate if any possibility can be shared.

Thanks & Regards

Ankit Yadav

[Wouter van den Berg]

Hi @Ankit Yadav 

The number of bugs created in the months (for e.g. 1st Aug'23 to 31st Aug'23)

• issuetype = Bug AND created >= 2023-08-01 AND created <= 2023-08-31
  
  

Bugs closed (including backlogs) in the months (for e.g. 1st Aug'23 to 31st Aug'23)

• issuetype = Bug AND status changed to Closed AFTER 2023-08-01 AND status changed to Closed BEFORE 2023-09-01
  
  

Data categorized by stage and criticality

• Not sure what you mean by stage but you can order by adding order by "Field you want to order on" followed by ASC or DESC (ascending or descending) like so: 
  
  issuetype = Bug AND created >= 2023-08-01 AND created <= 2023-08-31 order by priority ASC
  
  

Please elaborate on the stage. Btw. Did you know you can also click on Switch to Basic in order to make building JQL easier? 

[Ankit Yadav]

@Wouter van den Berg thanks for your response. I will try your suggestion and see if I get the desired report. Will keep you posted.

[Ankit Yadav]

@Wouter van den Berg I tried the above JQL but it did not work. I was wondering if multiple JQL will work in the same filter (I mean can I get all the above information in one filter/dashboard by applying those three JQL?).

Please advise.

Thanks & Regards

[Wouter van den Berg]

Am I understanding correctly you want to combine all 3 in 1?  Can you show me what your query looks like and or which didn't work? 

[Ankit Yadav]

@Wouter van den Berg sorry for responding you late. Yes you are right. We want to combine all 3 in 1.

However, total no. of bugs created in Aug'23 were 28. With the JQL shown in the image, only 8 bugs were shown.