topic Re: Too much annotations in Dashboards & Visualizations

Too much annotations

wbolten — Fri, 07 Feb 2020 11:19:19 GMT

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>

Re: Too much annotations

wbolten — Fri, 07 Feb 2020 12:33:22 GMT

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.

Re: Too much annotations

nickhills — Fri, 07 Feb 2020 13:53:42 GMT

Great news!

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

Re: Too much annotations

wbolten — Fri, 07 Feb 2020 14:00:44 GMT

Thank you, I have done so.