Hi, I want to use on eazyBi Cloud the “Tempo Required Hours” coming from Tempo.
It works fine when all categories are collapsed but when I want to expand, the information is not shown → How can I get this information even if I want to expand the categories?
My goal is to have a clear understanding of the percentage of time spent on each category. Here you see I’ve the number of “Tempo Billed Hours” and I use this as the calculation → “Tempo Billed Hours” / “Tempo Required Hours” = “Hours spent %”. It works when I collapse but then I don’t get the info per category → What I’m looking for.
Thanks for your support.
Hello @Guillaume_Lorquet ,
The issue you’re seeing is that Tempo required hours are not split by Tempo categories in eazyBI. This is why you see “Infinity%” in your report - the calculation is trying to divide the Tempo billed hours by zero (as there are no required hours at the category level).
A solution would be to divide the Tempo billed hours for each category by the total Tempo required hours. You can create a new calculated measure using this formula:
([Measures].[Tempo billed hours]) /
([Measures].[Tempo required hours], [Tempo Category].CurrentHierarchy.DefaultMember)
This tuple formula references the Tempo required hours with the default member of the Tempo Category dimension, giving you the total required hours regardless of which category you’re looking at.
This way, you’ll get the percentage of time spent on each category relative to the total required hours.
Kind regards,
Gerda // support@eazybi.com
