In this exercise of the eazyBI training we want to mix the content of an Excel file with our Jira issues using an Account/cube of the one of the most famous plugins for Business Intelligence and Analytics for Atlassian Jira called eazyBI.

First we need an Excel file of course, we will use a column with the Jira issues keys in each row (We will use this column to match in the issues in the Jira cube/datasource).

Example:

Captura de pantalla 2019-07-16 a las 17.10.30

Now we can upload the file in eazyBI, go to your Jira cube and click in “Source Files

Captura de pantalla 2019-07-16 a las 17.09.55

Here you can push the Excel file, after this we need to map and configure the columns

Captura de pantalla 2019-07-16 a las 17.09.47

Now map the columns like in this picture:

Remember use the cube “Issues” as name, use dimension Issue and Level Issue en each column. In the Issue Key column select “Skip missing”. In the rest of columns set the name of each column as Property name.

Captura de pantalla 2019-07-16 a las 17.08.56

Import the Excel rows in the Jira cube. Then we can create a new report super easy!

Captura de pantalla 2019-07-16 a las 17.10.12

In rows select Issues dimension (and show only the Issue Key to see better the results)

In columns use “Measures” dimension and activate the custom properties (that’s super automatic!)

Captura de pantalla 2019-07-16 a las 17.11.22

Now you can see the results! Measures mixed! WOW! if your Excel has changes you can upload again and the data will be refreshed, amazing!

Captura de pantalla 2019-07-16 a las 17.11.42

That’s all!

By MrAddon

Advertisements
Posted by:.