Import from sql filter and ordering

i'm using an import from sql and i'm unable to order the measures, filter by time and employee. I'm wondering what I'm missing. To create this report.ezbiImport.png

3 answers

Hi Matthew,

Is this a separate cube you are importing the data in? Are there any other dimensions created from another source import? I do not see any measure imported - you are not importing the actual hours spent?

As well, could you please let me know why you do not use the standard eazyBI Logged by dimension and Hours spent measure?

Kind regards,
Lauma / support@eazybi.com 

Hi Lauma

It is a separate cube with only one source i'm trying to grab the work logs from a single issue where I can filter by work logs creation date and log author.I'm not trying to grab how long they were working on the issue. with the standard eazyBI import I don't get work log description, And exact date of work log creation. (Unless I'm mistaken)

Hi Matthew,

You are correct, the worklog description is not imported to eazyBI. If you need this, you would create a new cube with mapping as in following screenshot Screen Shot - column mapping.png

With such mapping you will be able to create following report in the new worklog dimension Screen Shot - report example.png

Nevertheless, the worklog date is already imported to eazyBI. Please see example report here which shows hours spent by issue type and user grouped by week when they were logged. 

Let me know if you have any followup questions regarding this!
Lauma / support@eazybi.com 

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,316 views 14 20
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