2 EazyBI queries

Hi,

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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published 16 hours ago in Off-topic

Get to know our Atlassian User Group Leaders from Bengaluru, India

Meet @Dinesh Dhinakaran, @Vishnu Vasudeva, @Rajeev Verma, and Jamshid Nalakath: Our extraordinary AUG leaders from Bengaluru, India. These four work together to strengthen the bonds of their local co...

116 views 0 4
Read article

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