Count Text field fast

Hi community

We import a custom text field Office to EasyBI

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

We create a custom measure Office

      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 ?

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

1 Like