Forum Discussion
Anonymous
2 years agoNot applicable
Line Graph - Show Only Lines Below Threshold Line
Hi Everyone, Need some advice on how to display only lines that have a value below my SLA line? I have this line graph that shows applications and their uptime % across the year. However, I want ...
TomMartens
Super User
2 years agoHey Anonymous ,
creating a measure is the way to go.
But you do need to check if there is any value in the series that is above/below the SLA, if this is the case than the measure returns e.g. 1 for every data point in the series, instead of checking the an individual data point.
You can achieve this by creating a measure like so
measure to hide series =
if(
countx(
allselected(<the column from the xaxis>)
, if( [datapoint] < [sla]
, 1
, blank()
)
) > 1
, 1
, blank()
)
Hopefully, this provides what you are looking for.
Regards,
Tom