https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379536#M40698 <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/6059i77111BB755A45603/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span>I have the following query, however, the sparkline didn't show the trend instead one single value everything else is a straight line. what did I miss</P> <PRE><CODE> sourcetype=metrics name=http*://* rename "data.avg_response_time_ms" as avg_response_time_sec , "data.avg_error_rate" as avg_error_rate | eval avg_response_time_sec=avg_response_time_sec/1000 | eval avg_response_sec=round(avg_response_sec,2)| stats sparkline(avg(avg_response_time_sec),5m) as Trend by name,avg_response_time_sec ,avg_error_rate </CODE></PRE> Wed, 07 Nov 2018 22:35:53 GMT raindrop18 2018-11-07T22:35:53Z https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379536#M40698 <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/6059i77111BB755A45603/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span>I have the following query, however, the sparkline didn't show the trend instead one single value everything else is a straight line. what did I miss</P> <PRE><CODE> sourcetype=metrics name=http*://* rename "data.avg_response_time_ms" as avg_response_time_sec , "data.avg_error_rate" as avg_error_rate | eval avg_response_time_sec=avg_response_time_sec/1000 | eval avg_response_sec=round(avg_response_sec,2)| stats sparkline(avg(avg_response_time_sec),5m) as Trend by name,avg_response_time_sec ,avg_error_rate </CODE></PRE> Wed, 07 Nov 2018 22:35:53 GMT https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379536#M40698 raindrop18 2018-11-07T22:35:53Z https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379537#M40699 <P>Is it correct that avg_response_time_sec exists in ”by name, avg_response_time_sec, avg_error_rate”?</P> Tue, 29 Sep 2020 21:57:37 GMT https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379537#M40699 HiroshiSatoh 2020-09-29T21:57:37Z https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379538#M40700 <P>yes. that's correct and return the data.</P> Thu, 08 Nov 2018 17:01:34 GMT https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379538#M40700 raindrop18 2018-11-08T17:01:34Z https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379539#M40701 <P>Is the numerical value of avg_response_time_sec rounded to 0?<BR /> 0.000001 is displayed, but 0.0000001 is 0.</P> Tue, 29 Sep 2020 21:57:18 GMT https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379539#M40701 HiroshiSatoh 2020-09-29T21:57:18Z https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379540#M40702 <P>I have updated with rounding to 2 decimal point but the sparkling still not changed, also attached screenshot.</P> Wed, 21 Nov 2018 20:09:09 GMT https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379540#M40702 raindrop18 2018-11-21T20:09:09Z https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379541#M40703 <P>The screen image and the search sentence do not match.<BR /> Please upload the correct search sentence again. Also please tell me the extraction period.</P> Mon, 26 Nov 2018 02:37:55 GMT https://community.splunk.com/t5/Dashboards-Visualizations/sparkline-not-show-trends/m-p/379541#M40703 HiroshiSatoh 2018-11-26T02:37:55Z