Splunk Search

How to display multiple data points when hovering on one data point on timechart line graph?

bgeshk
Engager

The issue I run into is if, at a given time, the # of apples, oranges and pears are all let's say 8, then it appears as one single point on the graph. Also, when you hover over the data point, you only see 1 of the data values, instead of all 3. I want to hover over a given data point at a given time and display all values that were logged at that time.

Search used for this theoretical example:

my_search | timechart sum(apples) as apples sum(oranges) as oranges sum(pears) as pears

Here is a screenshot:

alt text

0 Karma

logloganathan
Motivator

Hi bgeshK,

Could you please use column chart

Splunk visualization or dashboard provide two dimensional views with x axis and y axis. here time is in x axis and others values in y-axis.

actually your query is working when i modified and tried as follows

here i used only column chart but it working fine

| makeresults | eval apples=8 | append [ | makeresults | eval oranges=8 ] | append [ | makeresults | eval pears=8 ] | timechart sum(apples) as apples sum(oranges) as oranges sum(pears) as pears

you will see the result at the end of the chart with three colored line

0 Karma

bgeshk
Engager

The problem with column chart is that in my real example, there will be 5 numbers at a time and it's not easy to tell if there's a discrepancy in the 5 numbers or not by just looking at the vertical bars because if the number is really high, it could look the same, but could be 1 or 2 values off

0 Karma

logloganathan
Motivator

There are only two ways
1) There is a option called trellis, please click that then "tick the 'use trellis layout' " it will show the result separately

OR

2) In Column chart: you can click the format option and click show data values "ON" after that you can see the values in the chart itself

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Quick connection discovery mode for forwarders

When a Splunk forwarder loses connectivity to its indexers, it does not always reconnect immediately. In many ...

Build and Launch AI Agents from Your Splunk Workflows

  Register We’ve all been there: juggling alerts, runbooks, and endless manual searches. What if you could ...

Splunk Cloud Application Management in Terraform

Register   On Tuesday, August 4 at 11AM PDT / 2PM EDT, we’re diving into how you can bring Infrastructure as ...