<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Realtime graph time axis in Dashboards &amp; Visualizations</title>
    <link>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96987#M5296</link>
    <description>&lt;P&gt;UPDATE: &lt;/P&gt;

&lt;P&gt;Indeed the earliest/latest bounds of the search appear to not survive the freezing process. So when the postProcess timechart gets to it, it implicitly snaps in around the actual data. &lt;/P&gt;

&lt;P&gt;Here's one weird thing you might try.  It adds 2 extra phantom events into any search. One whose _time value is the info_min_time, one whose _time is the info_max_time.  If you add this to your base search theoretically it'll force the postProcess to keep the original bounds. &lt;/P&gt;

&lt;P&gt;&lt;CODE&gt;&amp;lt;your search&amp;gt; | append [&lt;BR /&gt;
    stats count | eval earliest=1 | addinfo | transpose &lt;BR /&gt;
    | search column="info_min_time" OR column="info_max_time" &lt;BR /&gt;
    | rename "row 1" as value &lt;BR /&gt;
    | eval _time=if(match(column,"info_max_time"),value,_time) &lt;BR /&gt;
    | eval _time=if(match(column,"info_min_time"),value,_time) ]&lt;/CODE&gt;&lt;/P&gt;

&lt;P&gt;PREVIOUS ANSWER: &lt;/P&gt;

&lt;P&gt;I assume you're not using timechart?  Because timechart will always leave empty leading and trailing buckets, even when there's postProcess involved.  So either you're doing &lt;CODE&gt;stats foo by _time&lt;/CODE&gt; manually or there must be something else going on.  &lt;/P&gt;

&lt;P&gt;Can you paste in the search you're using?&lt;/P&gt;</description>
    <pubDate>Mon, 28 Sep 2020 09:32:20 GMT</pubDate>
    <dc:creator>sideview</dc:creator>
    <dc:date>2020-09-28T09:32:20Z</dc:date>
    <item>
      <title>Realtime graph time axis</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96986#M5295</link>
      <description>&lt;P&gt;Is there any way to tell a realtime graph to always show the last hour, even if there is only data for a small part of that time?&lt;/P&gt;

&lt;P&gt;To make things more interesting, this is a FlashChart in a PostProcess in an advanced xml dashboard, so fixedrange doesn't work.&lt;/P&gt;</description>
      <pubDate>Fri, 06 May 2011 20:34:55 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96986#M5295</guid>
      <dc:creator>vbumgarner</dc:creator>
      <dc:date>2011-05-06T20:34:55Z</dc:date>
    </item>
    <item>
      <title>Re: Realtime graph time axis</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96987#M5296</link>
      <description>&lt;P&gt;UPDATE: &lt;/P&gt;

&lt;P&gt;Indeed the earliest/latest bounds of the search appear to not survive the freezing process. So when the postProcess timechart gets to it, it implicitly snaps in around the actual data. &lt;/P&gt;

&lt;P&gt;Here's one weird thing you might try.  It adds 2 extra phantom events into any search. One whose _time value is the info_min_time, one whose _time is the info_max_time.  If you add this to your base search theoretically it'll force the postProcess to keep the original bounds. &lt;/P&gt;

&lt;P&gt;&lt;CODE&gt;&amp;lt;your search&amp;gt; | append [&lt;BR /&gt;
    stats count | eval earliest=1 | addinfo | transpose &lt;BR /&gt;
    | search column="info_min_time" OR column="info_max_time" &lt;BR /&gt;
    | rename "row 1" as value &lt;BR /&gt;
    | eval _time=if(match(column,"info_max_time"),value,_time) &lt;BR /&gt;
    | eval _time=if(match(column,"info_min_time"),value,_time) ]&lt;/CODE&gt;&lt;/P&gt;

&lt;P&gt;PREVIOUS ANSWER: &lt;/P&gt;

&lt;P&gt;I assume you're not using timechart?  Because timechart will always leave empty leading and trailing buckets, even when there's postProcess involved.  So either you're doing &lt;CODE&gt;stats foo by _time&lt;/CODE&gt; manually or there must be something else going on.  &lt;/P&gt;

&lt;P&gt;Can you paste in the search you're using?&lt;/P&gt;</description>
      <pubDate>Mon, 28 Sep 2020 09:32:20 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96987#M5296</guid>
      <dc:creator>sideview</dc:creator>
      <dc:date>2020-09-28T09:32:20Z</dc:date>
    </item>
    <item>
      <title>Re: Realtime graph time axis</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96988#M5297</link>
      <description>&lt;P&gt;Search module with a search of foo, earliest of rt-1h, latest of rt. &lt;BR /&gt;
PostProcess module with a search of |timechart span=1m count by bar. &lt;/P&gt;

&lt;P&gt;If I run the full query in Advanced Charting, it works as expected.&lt;/P&gt;</description>
      <pubDate>Sat, 07 May 2011 00:07:53 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96988#M5297</guid>
      <dc:creator>vbumgarner</dc:creator>
      <dc:date>2011-05-07T00:07:53Z</dc:date>
    </item>
    <item>
      <title>Re: Realtime graph time axis</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96989#M5298</link>
      <description>&lt;P&gt;That doesnt seem right.  At least when you split this up into a base search and a postprocess search,  Splunk wont extract the 'bar' term cause it doesnt know anyone cares about 'bar'.   maybe this is an oversimplified example?&lt;/P&gt;</description>
      <pubDate>Sat, 07 May 2011 00:35:20 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96989#M5298</guid>
      <dc:creator>sideview</dc:creator>
      <dc:date>2011-05-07T00:35:20Z</dc:date>
    </item>
    <item>
      <title>Re: Realtime graph time axis</title>
      <link>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96990#M5299</link>
      <description>&lt;P&gt;This is indeed an oversimplified example. bar is referenced in the initial query, so it does work. The only problem is that the timechart has a timeline exactly scaled to the events seen, not the last hour.&lt;/P&gt;</description>
      <pubDate>Sat, 07 May 2011 00:42:30 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Dashboards-Visualizations/Realtime-graph-time-axis/m-p/96990#M5299</guid>
      <dc:creator>vbumgarner</dc:creator>
      <dc:date>2011-05-07T00:42:30Z</dc:date>
    </item>
  </channel>
</rss>

