Calculation of incorrect hours and minutes in eazyBi

I need to create a custom field by calculating estimated hours, hours remaining and hours spent in a report, but setting ## h ## m, the hour and minute values end up repeating as in the image below:

horas _duplicadas.PNG

How can I resolve for my report to bring estimated hours, hours remaining and hours spent according to the filter used?

1 answer

Hi,

 

The formatting you have selected (## h ## m) requires that value is converted to minutes in order to display results in hours and minutes.

I believe you could create new calculated members in "Measures" dimension and then you can multiply hour-related measures with 60 the to get result in minutes.

 

Kind regards,

Martins / eazyBI support

Hello @Mārtiņš Vanags ,

Greetings!

Is it possible to convert those converted values to number of days (#h #m to number of days)?

Eg: if converted value is 72h, then number of days should be 9 (Considering that the number of hours per day = 8 hours)

Regards,

Pooja

Hi @Pooja Singh ,

 

For days you could use the same approach @Mārtiņš Vanags suggested - multiplying the hours by 60 and select the 'Days Hours Minutes' formatting.

To display it in the workday fashion - 1 day = 8 hours, try to create a calculated measure with the formula below:

(Case 
When [Measures].[Hours spent]>8
Then Format(Int([Measures].[Hours spent]/8)
,"0d ")
Else ""
End)

||

(Case
When [Measures].[Hours spent]>=1
Then Format([Measures].[Hours spent]
- Int([Measures].[Hours spent]/8) * 8
,"0h ")
Else ""
End)

||

(Case
When [Measures].[Hours spent]>0
Then Format(
(([Measures].[Hours spent] -
Int([Measures].[Hours spent]/8) * 8) -
Int([Measures].[Hours spent] -
Int([Measures].[Hours spent]/8) * 8))*60
,"00m")
Else ""
End)

 

Kind regards,

Roberts / eazyBI support

Like 1 person likes this

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 13, 2019 in Marketplace Apps

Marketplace Spotlight: Marketing apps for Confluence to keep your teams working on the same page

                                                      &nbsp...

251 views 0 6
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