Good morning all,
I’m fairly new to eazyBI and can create basic reports easily. My latest issue is only reporting on issues that we created within the past 24 hours. Any help?
Thanks!
Brandon Viertel
Good morning all,
I’m fairly new to eazyBI and can create basic reports easily. My latest issue is only reporting on issues that we created within the past 24 hours. Any help?
Thanks!
Brandon Viertel
Hi @bavierte
eazyBI has no hour level in “Time” dimension therefore, the last “24 hours” calculation would not be that basic anymore, but there are some other options using calculated measures.
Try creating a new calculated measure using this formula:
NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
DateDiffHours(
[Measures].[Issue created date],
now()
)<24
AND
[Measures].[Issues created]>0
)
)
)
It would be much easier to calculate the issues created on the previous day
Martins / eazyBI support
@martins.vanags I tried this but it did not work. It seems to just show all tasks. When i tried creating the calculated member EazyBI gave me a warning: " Do not use the other dimension Issue when defining a calculated member in Time . Create complex calculations in Measures ."
How do I get this to work?
Thanks,
Joe
The code I sent earlier must be used to create a new calculated measure not a calculated member in “Time” dimension.
Martins / eazyBI support