Trend line is not getting displayed

[Chinmai]

Hello,

I am using the following search string to get a trend line on the column chart in the visualization tab. But i am getting only column chart but not trend line. Can anyone please help me with this?

index=abc | chart sum(RES_CONF_ID) as count over MO_NAME by YR_NUM useother=f |lookup Lookup_month MO_NAME output MO_OF_YR_NUM | sort + MO_OF_YR_NUM | fields - MO_OF_YR_NUM | trendline wma2(sum(RES_CONF_ID)) as trend

Thanks in advance.

[martin_mueller]

Do you see a trend field in the tabular/statistics view of your data?

If so, all you need to get a line is to switch back to the visualization tab, and format your column chart's overlay field to be the trend field.
If not, you will first need to figure out what's wrong with your search.