Jump to content

Trying to run a measure and exclude all teams starting with EPR

Recommended Posts

I am trying to run a measure that excludes all teams from showing in the results that begin with EPR

I have been using this in the 'Query where clause' bit is: WHERE h_fk_team_name NOT LIKE 'EPR%'

but I don't think this is giving me a true result? can anyone help?


The point of this measure is to count how many incident tickets were resolved within our agreed SLA'S last month. But only for ICT teams (we have a separate department who's teams all start with EPR that i wish to exclude)

Many thanks


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...