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 / support@eazybi.com 

Suggest an answer

Log in or Join to answer
Community showcase
Maarten Cautreels
Posted Thursday in Off-topic

Friday Fun: What's your favourite beer/drink

As a Belgian, beer-lover and home brewer, beer is one of my great passions. I love the fact that with just a few ingredients (usually just water, hop and malt) you can create so many different tastes...

281 views 38 9
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot