I've seen various questions about comparing two events in Splunk.
This question is specifically about designing a Splunk Web dashboard user interface to enable users to select two events to compare.
My initial thoughts involve two side-by-side events list visualizations, where each events list has an associated time picker UI control:
However, I haven't yet got around to implementing this in practice. It occurs to me that, although I haven't found an exact duplicate question, this is likely to be a common use case—a problem already solved—so I thought I'd ask here first.
What arrangement of UI controls and visualizations in a dashboard is generally regarded as optimal for selecting two events from two different time periods, where the time periods might be arbitrarily different? For example, we're not necessarily comparing events for the same time-of-day on two different days.
@Graham_Hannington ,
Here is a run anywhere example. You may choose the visualizations suitable to represent your data .
1. Left panel displays count of sourcetype per 5 minutes - controlled via time picker assigned for the panel
2. RIght panel gets avg (count/5minutes) - controlled via time picker assigned for the panel
3. Bottom panel displays event information based on the sourcetype selected from left panel. This can be repeated for right panel as well
<form>
<label>Event Comparison</label>
<fieldset submitButton="false"></fieldset>
<row>
<panel>
<input type="time" token="field1">
<label></label>
<default>
<earliest>-15m</earliest>
<latest>now</latest>
</default>
</input>
<chart>
<search>
<query>index=_internal|timechart span=5m count by sourcetype</query>
<earliest>-15m</earliest>
<latest>now</latest>
</search>
<option name="charting.chart">column</option>
<option name="charting.chart.stackMode">stacked</option>
<option name="charting.drilldown">all</option>
<option name="refresh.display">progressbar</option>
<drilldown>
<set token="sourcetype">$click.name2$</set>
</drilldown>
</chart>
</panel>
<panel>
<input type="time" token="field2">
<label></label>
<default>
<earliest>-4h@m</earliest>
<latest>now</latest>
</default>
</input>
<chart>
<search>
<query>index=_internal|timechart span=5m count by sourcetype
|untable _time,sourcetype,count|stats avg(count) as avg by sourcetype|eval avg=round(avg,2)</query>
<earliest>-4h@m</earliest>
<latest>now</latest>
</search>
<option name="charting.chart">line</option>
<option name="charting.drilldown">none</option>
<option name="refresh.display">progressbar</option>
</chart>
</panel>
</row>
<row>
<panel>
<event>
<search>
<query>index=_internal sourcetype="$sourcetype$"</query>
<earliest>-15m</earliest>
<latest>now</latest>
</search>
<option name="list.drilldown">none</option>
</event>
</panel>
</row>
</form>