Hide the rows with no status in a status history view

I have a Status history graph which shows the numerical value of the series in the status and matched to a color based in the numerical value.

How I have defined the statuses are using the “Thresholds” in absolute mode. As shown below.

My requirement is that I want to hide the data rows without any status shown in the above graph.

I was able to hide the time series graph using Override tab for the same data set as below

Before doing the above there were so many legend labels (more than 50) in the graph. Doing above I was able to hide the legends which has no value (null or zero) during the time period shown in the graph.

I tried to do the same thing with the Status history view. I can select the “Fields with Value”. But it doesn’t show me the Series>Hide In Area option. It has some other options.

Can you please help me to remove the data rows without a status in the status history graph.

You can add a transformation to filter out the values you don’t want.

Yes. The problem here is I have to do that to each field separately. As I said there are more than 50 such fields. So it is not scalable.

It is the row names shown in the left side of the “Status History” graph which comes in to the drop down of the field. The same that appears in the legend labels of the time series graph. (In the image I have blacked out the name texts, but you can see the color strips for each legends, showing the number of labels.

What is your datasource? Mysql or postgres or ?

Its Graphite.

Still looking for a solution here.


1 Like

Thanks a lot. This worked like a charm. For others if it helps previously my query was like below.

summarize(nonNegativeDerivative(seriesByTag(‘host=${xyz}’,‘name=~counterPrefix.*’, ‘metricattribute=count’)),“60min”,“sum”)|aliasByTags(“name”)

And in the question you can see the respective graph for the above query.

I added removeEmptySeries like below

summarize(removeEmptySeries(nonNegativeDerivative(seriesByTag(‘host=${xyz}’, ‘name=~counterPrefix.*’, ‘metricattribute=count’))),“60min”,“sum”)|aliasByTags(“name”)

The new graph is as below