Why is my visualization adding extra time span while searching with day?

[dkssingh2005]

while searching with day span, Its working fine with multiple dates but creating issue when searching within day. It adding extra time span in with day like 2:00 AM, 6:00 AM etc.

Below are the code snippet for the row. Have any solution for this?

<row>
<panel>
<title>API Count by Environment - Success</title>
<chart>
<search>
<query>index="cust-*-wfd-api-gtw-ilb" "/v1/platform/change_indicators" (host="*$env$*") | search sourcetype="nginx:plus:access" | where like(status, "%2%%") |eval env = mvindex(split(host, "-"), 1) | timechart span=$timespan$ count(request) as TotalCount by env</query>
<earliest>$timepicker.earliest$</earliest>
<latest>$timepicker.latest$</latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
<option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option>
<option name="charting.axisTitleX.text">Time</option>
<option name="charting.axisTitleX.visibility">visible</option>
<option name="charting.axisTitleY.text">Request Count</option>
<option name="charting.axisTitleY.visibility">visible</option>
<option name="charting.axisTitleY2.visibility">visible</option>
<option name="charting.axisX.abbreviation">none</option>
<option name="charting.axisX.scale">linear</option>
<option name="charting.axisY.abbreviation">auto</option>
<option name="charting.axisY.scale">linear</option>
<option name="charting.axisY2.abbreviation">none</option>
<option name="charting.axisY2.enabled">0</option>
<option name="charting.axisY2.scale">inherit</option>
<option name="charting.chart">area</option>
<option name="charting.chart.bubbleMaximumSize">50</option>
<option name="charting.chart.bubbleMinimumSize">10</option>
<option name="charting.chart.bubbleSizeBy">area</option>
<option name="charting.chart.nullValueMode">gaps</option>
<option name="charting.chart.showDataLabels">all</option>
<option name="charting.chart.sliceCollapsingThreshold">0.01</option>
<option name="charting.chart.stackMode">stacked</option>
<option name="charting.chart.style">shiny</option>
<option name="charting.drilldown">none</option>
<option name="charting.layout.splitSeries">0</option>
<option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
<option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
<option name="charting.legend.mode">standard</option>
<option name="charting.legend.placement">right</option>
<option name="charting.lineWidth">2</option>
<option name="refresh.display">progressbar</option>
<option name="trellis.enabled">0</option>
<option name="trellis.scales.shared">1</option>
<option name="trellis.size">medium</option>
</chart>
</panel>
</row>

[ITWhisperer · Accepted solution]

You have an area chart with a single point for each series - it cannot draw a line for the series because there is only one point - you would get the same issue with a line graph.

Try using a different chart type.

[dkssingh2005]

@ITWhisperer ,Thanks for your response. Its a limitation for line and area chart. Its working for other chart like column.