Only Report On Issues That Were Created In A Specific Timeframe

Questions & Answers
1

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

2

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

3

@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

4

@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

5

Hi @martins.vanags,

Thanks for the calculated measure hint. I tried your code but it unfortunately says “Query execution timeout of 60 seconds reached.”

Maybe I have too many issues added to my account? (only around ~25k)

Also when I deselect the measure it says

Failed to parse query, try to make query simpler.
Or maybe saved report uses deleted calculated member.
Error message:
All arguments to function ‘{}’ must have same hierarchy.

Thanks.

6

@pingween
account size matters for such custom calculations.
Try this updated version of the same code.

Sum(
  Filter(
    Filter(
      Descendants(
        [Issue].CurrentHierarchyMember,
        [Issue].[Issue]
        ),
      DateDiffHours(
      [Measures].[Issue created date],
      now()
      )<24
    ),
    DateInPeriod(
      [Measures].[Issue created date],
      [Time].CurrentHierarchyMember
    )
  ),
  [Measures].[Issues created]
)

That should calculate the same in a slightly faster way.

But the error must be something else.
Please contact eazyBI support and share your report defintion exported to a text file.

Martins / eazyBI