Table with Sparklines for multiple key/value pairs

[giovere]

Hi All

Logged events look something like this:

10:00 ComponentA: 3 ComponentB: 5 ComponentC: 8
10:01 ComponentA: 3 ComponentB: 4 ComponentC: 10
10:02 ComponentA: 5 ComponentB: 2 ComponentC: 12

Number of components is fixed, ideally I’d like to have a table with the latest value for component and a sparkline for the past 30 minutes or so.

Component  | Value| Sparkline
ComponentA | 5    | Sparkline(3,3,5)
ComponentB | 2    | Sparkline(5,4,2)
ComponentC | 12   | Sparkline(8,10,12)

(Optional) Bonus sub-step would be adding coloring map per row (Component)? Found in documentation a way to define it per table, but each Component has different threshold.

Any help much appreciated.
Thanks in advance

[somesoni2 · Accepted solution]

This should do the trick

your base search giving fields _time, ComponentA, ComponentB, ComponentC | fields _time, ComponentA, ComponentB, ComponentC | untable _time Component Value | stats latest(Value) as Value sparkline as Sparkline by Component

[sunnyparmar]

It works for me as well. thanks

[giovere]

Thanks, this works quite well, except one thing. Is there a way to get sparkline(latest(Value),8h)? Apparently by default it supports aggregation functions like avg, mean, max etc., but what I'd rather have is a latest value for a given span.

[esix_splunk]

You cant do this for specific aggregates unluss you rework your whole search. Otherwise you can add
... | bin _time span=8h | ..

Thats if I understand you're wanting to group all these together into 8h buckets.

[giovere]

sure enough, it works with splitting it into bins. Thanks!