This is an example of report done with Jira and eazyBI to obtain a Ratio% of effective work hours per group of users.

For example, we can calculate the Ratio with the next formula.

Ratio per week = Effective Hours / ( 38h – Hours of vacations). If we usually work 38h/week for example

and…

Effective Hours = Total Hours – Hours in the project “INTERNAL”

To start, we need to create some Calculate Measures in our report. Like these pictures.

One for “Internal Hours Spent

Captura de pantalla 2018-02-25 a las 15.47.33

Another one for “Vacations Hours

Captura de pantalla 2018-02-25 a las 15.45.56

And other one to calculate the “Effective Hours Spent

Captura de pantalla 2018-02-25 a las 15.47.14

And finally, the “Ratio” formula.

Captura de pantalla 2018-02-25 a las 15.45.36

But, if we want to calculate the Average value of all users of the group, we need to write a more complex Measure, like this. “Ratio Avg

Captura de pantalla 2018-02-25 a las 15.45.09

Finally, we got some report like this:

Captura de pantalla 2018-02-25 a las 15.48.25

We can show beautiful reports of the Ratio by group like this:

Captura de pantalla 2018-02-25 a las 15.48.08

Many thanks as always to the eazyBI Support Team!

Post by MrAddon

Advertisements
Posted by:.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s