https://community.splunk.com/t5/Getting-Data-In/How-to-optimize-view-of-a-line-chart-in-Splunk/m-p/585597#M103012 <P>Hi Everyone, I'm working on a Splunk dashboard visualisation using a line chart, and I span the data for every 1week.But the line is not consistent if there is no data and I see dots scattered here and there. Is there a way to optimise this view. Attached is the screenshot. Thanks</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2022-02-17 at 2.13.32 PM.png" style="width: 999px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/18026i0D17394C94A4613E/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2022-02-17 at 2.13.32 PM.png" alt="Screenshot 2022-02-17 at 2.13.32 PM.png" /></span></P> <P>&nbsp;</P> <LI-CODE lang="markup">index = "abc" Environment = $environment$ ProcessName=*$task$* LogType = "*" TaskName =* |bucket span=1w _time |stats count(eval(LogMessage = "errorneously")) as Failed_Count, count(eval(LogMessage = "execution")) as Success_Count ,count(eval(LogMessage = "execution2")) as Success_Count1 by _time |eval tot_count= Failed_Count + Success_Count + Success_Count1|eval scount=Success_Count + Success_Count1 | eval succ_per=round((scount/tot_count)*100,0) |timechart span=1w avg(succ_per)</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 17 Feb 2022 16:00:10 GMT kranthimutyala 2022-02-17T16:00:10Z https://community.splunk.com/t5/Getting-Data-In/How-to-optimize-view-of-a-line-chart-in-Splunk/m-p/585597#M103012 <P>Hi Everyone, I'm working on a Splunk dashboard visualisation using a line chart, and I span the data for every 1week.But the line is not consistent if there is no data and I see dots scattered here and there. Is there a way to optimise this view. Attached is the screenshot. Thanks</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2022-02-17 at 2.13.32 PM.png" style="width: 999px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/18026i0D17394C94A4613E/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2022-02-17 at 2.13.32 PM.png" alt="Screenshot 2022-02-17 at 2.13.32 PM.png" /></span></P> <P>&nbsp;</P> <LI-CODE lang="markup">index = "abc" Environment = $environment$ ProcessName=*$task$* LogType = "*" TaskName =* |bucket span=1w _time |stats count(eval(LogMessage = "errorneously")) as Failed_Count, count(eval(LogMessage = "execution")) as Success_Count ,count(eval(LogMessage = "execution2")) as Success_Count1 by _time |eval tot_count= Failed_Count + Success_Count + Success_Count1|eval scount=Success_Count + Success_Count1 | eval succ_per=round((scount/tot_count)*100,0) |timechart span=1w avg(succ_per)</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 17 Feb 2022 16:00:10 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-optimize-view-of-a-line-chart-in-Splunk/m-p/585597#M103012 kranthimutyala 2022-02-17T16:00:10Z https://community.splunk.com/t5/Getting-Data-In/How-to-optimize-view-of-a-line-chart-in-Splunk/m-p/585610#M103013 <P>Hi</P><P>you could try makecontinuous and fillnull to stretch and fill those with some defaults.</P><P>r. Ismo</P> Thu, 17 Feb 2022 17:26:17 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-optimize-view-of-a-line-chart-in-Splunk/m-p/585610#M103013 isoutamo 2022-02-17T17:26:17Z https://community.splunk.com/t5/Getting-Data-In/How-to-optimize-view-of-a-line-chart-in-Splunk/m-p/585614#M103014 <P>Set the format to zeroes</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ITWhisperer_0-1645119596969.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/18027i81E1F124305CBEAC/image-size/medium?v=v2&amp;px=400" role="button" title="ITWhisperer_0-1645119596969.png" alt="ITWhisperer_0-1645119596969.png" /></span></P><P>&nbsp;</P> Thu, 17 Feb 2022 17:40:33 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-optimize-view-of-a-line-chart-in-Splunk/m-p/585614#M103014 ITWhisperer 2022-02-17T17:40:33Z