Jump to content

Question about WHERE clause in a measure


chriscorcoran
 Share

Recommended Posts

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

image.png

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

image.png

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

image.png

Hope that helps

 

Link to comment
Share on other sites

  • Victor changed the title to Question about WHERE clause in a measure

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...