I try to plot a line graph where the x-axis is an index and y-axis is a random value. I also trying to add an annotation where the annotationX is an index. Below is the code for the visualization.
"visualizations": {
"viz_kHEXe45c": {
"type": "splunk.area",
"dataSources": {
"primary": "ds_Search_1",
"annotation": "ds_annotation_markers"
},
"options": {
"x": "> primary | seriesByIndex(0)",
"annotationX": "> annotation | seriesByIndex(0)",
"annotationLabel": "> annotation | seriesByIndex(1)",
"annotationColor": "> annotation | seriesByIndex(2)",
"nullValueDisplay": "zero"
},
"title": "Test Event Annotation",
"showProgressBar": false,
"showLastUpdated": false
}
},
"dataSources": {
"ds_Search_1": {
"type": "ds.search",
"options": {
"query": "| makeresults count=15\n| streamstats count\n| eval index=count\n| eval value=random()%100\n| fields index value"
},
"name": "ds_Search_1"
},
"ds_annotation_markers": {
"type": "ds.search",
"options": {
"query": "| makeresults count=3\n| streamstats count\n| eval index=count\n| eval score = random()%3 +1\n| eval status = case(score=1,\"server error detected\", score=2, \"unknown user access\", score=3, \"status cleared\")\n| eval color = case(score=1,\"#f44271\", score=2, \"#f4a941\", score=3, \"#41f49a\")\n| table index status color"
},
"name": "ds_annotation_markers"
}
},
Below is the line graph output shown based on the code above.
Could anyone please help how to add the annotation on the line graph when the x-axis is a non-time based number type?
Hi @yoongchean It might be because makeresults generates the _time field, which Splunk automatically puts on the x axis when no chart options are specified. Try simply removing the _time field with
| fields - _time
Hi @KendallW , I have add the fields - _time at the last SPL command to remove the _time field. Unfortunately, it still doesn't show the annotation in the line graph.