Jump to content

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


yelyah.nodrog
 Share

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?

Capture.thumb.PNG.46071325dca817fab16b0f42ef8fb5f2.PNG

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

H

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
 Share

×
×
  • Create New...