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 / 

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 / 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,236 views 5 10
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