I have db queries running every 5 minutes each logging a record of multiple fields and values. I have the following single value panel defined:
<single>
<title>Entered</title>
<search>
<query>index=db_index| regex source="db_prod/.*entered.*" | timechart span=5m dc(id)</query>
<earliest>$field1.earliest$</earliest>
<latest>$field1.latest$</latest>
<refresh>3m</refresh>
<refreshType>delay</refreshType>
</search>
<option name="colorBy">trend</option>
<option name="colorMode">none</option>
<option name="drilldown">all</option>
<option name="numberPrecision">0</option>
<option name="rangeColors">["0x65a637","0x6db7c6","0xf7bc38","0xf58f39","0xd93f3c"]</option>
<option name="rangeValues">[0,30,70,100]</option>
<option name="refresh.time.visible">1</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="trendInterval">-1h</option>
<option name="underLabel">Compared to Previous Hour</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">1</option>
</single>
Looking at the values displayed in the panel, I'm having difficulty understanding how the single value and the displayed trend are being calculated. The questions I have are:
With the declared search and associated parameters which data point/points are picked to compute the single value?
Which data points are used to compute the trend value?
... View more