Jump to content

Recommended Posts

I have a measure which currently has a coloured threshold on it, as it is copied from a existing measure and modified. The new measure does not require the colour threshold setting the original had.

How do you remove the threshold colouring on a measure, so they appear as default dark grey and white writing?

I have tried setting the values to 0, but that does not work.

The only way I can find at the moment is to re-create the measure from scratch.

Cheers

Martyn
 

 

Share this post


Link to post
Share on other sites

As a workaround, whilst you are not able to set the target values back to zero in the user interface, is to update the h_data_measure table for the appropriate measure to zero via the Database Direct.

Cheers

Martyn

Share this post


Link to post
Share on other sites

The SQL code if you need to use the workaround.

update h_data_measures set h_target_warning=0, h_target_breach=0 where h_title='enter your measure title here'

Cheers

Martyn

  • Like 1

Share this post


Link to post
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...