Dashboards & Visualizations

trendline won't display

nikmeiser
Explorer

I have a simple trendline to track storage growth I want to display. I'm using the following syntax. There are no errors but the trendline won't display -

tag="host01" | eval MOUNTPT=mvfilter(match(MOUNTPT, "^/d/")) | eval USEDGB=round(X_USED/(1024*1024),2) | timechart max(USEDGB) | trendline sma5(USEDGB) as trend

Any ideas what I'm doing wrong?

Tags (1)
0 Karma
1 Solution

nikmeiser
Explorer

Figured it out. It needed a function around the field. This works -

tag="host01" | eval MOUNTPT=mvfilter(match(MOUNTPT, "^/d/")) | eval USEDGB=round(X_USED/(1024*1024),2) | timechart max(USEDGB) | trendline sma5(max(USEDGB)) as trend

View solution in original post

nikmeiser
Explorer

Figured it out. It needed a function around the field. This works -

tag="host01" | eval MOUNTPT=mvfilter(match(MOUNTPT, "^/d/")) | eval USEDGB=round(X_USED/(1024*1024),2) | timechart max(USEDGB) | trendline sma5(max(USEDGB)) as trend

View solution in original post

.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!