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

This widget could not be displayed.

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 / 

This widget could not be displayed.

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)

This widget could not be displayed.

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 / 

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

285 views 5 0
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