Only Report On Issues That Were Created In A Specific Timeframe

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

@Hardin2206

The code I sent earlier must be used to create a new calculated measure not a calculated member in “Time” dimension.

Martins / eazyBI support