Remove Threshold Colouring

[Martyn Houghton]

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
 

 

[Martyn Houghton]

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

[Martyn Houghton]

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