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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

2 EazyBI queries


We have installed EazyBI 3.4.3 in conjunction with JIRA Service Desk and are trying to get to grips with it.

I have 2 queries:

  1. I would like to produce a created issues line graph which covers the pevious month.
    At any datapoint, the graph should display the number of tickets created relative to that date on the x-axis.
  2. Also, I have a graph which displays open issues. When I drill through a datapoint, currently I see a list of the tickets associated with that datapoint. Additionally, I would like to display (in table form) the number of days each opened ticket has been opened for.

Hope both of these queries make sense.

I have been looking closely at calculated members but cannot see how to do this.

Many thanks,




bernard gorman

1 answer

Hi Bernard,

I see my colleague already answered your questions over e-mail. Nevertheless, I will write a short summary for these questions here.

  1.  'Issues created' measure combined with Time dimension shows how many issues were created at that period of time. If you select Time / Day on rows, you can click on any day and add Time filter between 'beginning of last month and first day of current month' to see only the previous month days and issues created in each of these days.
  2. Drill through issue shows the value of the measure that you are drilling through for each issue. To see how many days issues have been open, you can use Issue dimension on rows together with Average age days measure on columns - on individual issue level this will show how many days unresolved issues have been open.

Let us know if you have any follow up questions!
Kind regards,
Lauma / 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

5 mobile apps for Jira Cloud to boost productivity

  It’s very important to have access to the workflow process from anywhere. Especially if you manage the work of others. There is no difference whether you’re out of office, or drive a ca...

249 views 2 5
Read article

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