Question about WHERE clause in a measure

[chriscorcoran]

Hi

I have a measure that I want to exclude a 'site' from so my graphs are correct, so far the where clause is ((h_fk_servicename ='IECC') OR (h_fk_servicename ='IECC Scalable')) is it possible to include and exclusion for site Newcastle?

 

Thanks

Chris

[Steven Boardman]

HI @chriscorcoran you could do something like this

h_fk_servicename IN ('Desktop Support','Home Working') AND h_site != 'Leeds'

Giving me a measure which i can then use for my widgets

Grouped by Site, where Leeds has been excluded

 

Grouped by Service Name, where it is only the two services i specified above

Removing the != 'Leeds' clause and creating a chart shows the results including Leeds

 

Hope that helps

 

[chriscorcoran]

thanks  @Steven Boardman I had added too many brackets in my query as well. This works perfect. Thanks