Count Text field fast

Questions & Answers
,
1

Hi community

We import a custom text field Office to EasyBI

[jira.customfield_10280]
name = "Office"
data_type = "string"
dimension = true
measure = false
separate_table = false
changes = true

The offices are pulled from Azure and have consistent values like

  • Office 1
  • Office 2
    etc.

We create a custom measure Office

NonZero(
  Count(
    Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
      NOT IsEmpty([Measures].[Issue Office]) AND
      --measure to add context of the report
      [Measures].[Issues created] > 0 )
    )  
  )
)

This works but is very slow und we get a lot of time outs. (we have around 130k tickets)

Query execution timeout of 60 seconds reached.
Please try to make query simpler.

What is a better way which works faster ?

2

ah stupid me - Solution is very simple
Add Office to row and use measure Issue created

1 Like