Help Counting a Issue Custom Property with or without text in string filed

Hi All,

I have been reading through the forums, but have not found a solution to my problem.

I am trying to create a count of issues (within my filters) that contain a text field. The text field is for explaining why their was an SLA violation that was not a real miss. The end result I am trying to get to is to count SLA misses and then also count SLA misses that DO NOT contain an SLA explanation. That will tell me the true number of SLA misses versus the number that are explained away with review.

Here is the field within an issue

Further, I have brought this customer field in as an Issue property

Reading through the forums, it has come up several times to use the below formula when trying to count text fields that are empty or not empty. I keep getting the error message in the below screenshot

How do I resolve this error?

Hi @acreech

You have a syntax error in your formula - Isempty should have just one parameter.
But try this formula which would work faster:

Sum(
  Filter(
      DescendantsSet([Issue].Currentmember,[Issue].[Issue]),
      Not IsEmpty([Measures].[Issue SLA Violation Explanation])
    ),
  CASE WHEN
  [Measures].[Issues created]>0
  THEN
  1
  END
)

If you find your report with this calculation slow, please check how to create reports according to best practices:
https://docs.eazybi.com/eazybi/analyze-and-visualize/best-practices-for-report-creation

Martins / eazyBI

1 Like

Thank you!, this was perfect and fixed my report right up.