Too much annotations

[wbolten]

Hi,
I have created a bar chart that shows in my case example data on the CPU usage of a device with two overlays for inbound and outbound traffic.

When a certain combination of values is exceeded I want to place an annotation to highlight this. As shown in this example.

What I cannot seem to get rid off are the orange annotations that seem to be placed when the condition is not matched.

The search is as follows. In this I am evaluating and updating the label and the category.

<search type="annotation">
<query>index="bla" 
| timechart span=1m avg(inPercentUtil) as inPercentUtil avg(Percent_CPULoad) as Percent_CPULoad 
| eval critical=if(inPercentUtil>65 AND Percent_CPULoad>90,"Yes","No")
| eval annotation_category=case(critical="Yes","Critical")
| eval annotation_label=case(critical="Yes","Insert_Message")
 </query>

What should I do to stop the orange markers from showing? I don't even specify a color for the annotations.

<option name="charting.annotation.categoryColors">{"Critical":"0xe60000"}</option>

[wbolten · Accepted solution]

Right, been staring at this for ages but it seems to be solved.

It was suggested to only select the moments to place the annotation from the search rather then look for them from the result.

Changed the annotation query to

index="bla" | search inPercentUtil>65 AND Percent_CPULoad>90
| eval annotation_category="Critical"
| eval annotation_label="Insert_Message"

Now it is working.

[nickhills]

Great news!

I have converted your comment to an answer. Please accept it so others can see how you resolved your issue.

[wbolten]

Thank you, I have done so.