Dashboards & Visualizations

Zoom panel with Pan and Zoom

PavelNed
Explorer

Hello guys,

I implemented a Pan and Zoom functionality this way: I have a line graph that shows some data and a table below that shows raw events within selected time range. It works as expected, but I would like to modify it a bit. It should work just like this:

pan and zoom problem - Splunk Community

Unfortunately nobody answered, maybe because of rude formulation. So, to make it clearer, instead of zooming this way:

PavelNed_0-1607609506690.png

I am looking for a way to zoom like in normal graph (change x axis, not show two markers) so I can see more detailed data.

Any ideas how to achieve that?

Thank you!

Labels (3)
0 Karma

chiliconbeano
Path Finder

This is a related question..not an answer.  Using the Pan and Zoom ( <selection></selection> ) feature, how does one get the 'earliest' / 'lastest' time range values represented by the Pan/Zoom window?  Currently, I can only get the single 'click.value'  epoc time where the mouse is clicked.  Is there special value

Also, it appears the 'click' names/values are not available in the <selection></selection> group, but they are available in the <drilldown></drilldown> group.

To work around this 'problem', I am doing the following which I do not like. The <selection>..</selection> group is just to enable the pan/zoom visualization.  I've tried setting the 'selection.latest/earliest' values to both $start$/$end$   AND $selection_earliest$/$selection_latest$...no worky!

<selection>
<set token="selection_made">1</set>
</selection>

<drilldown>
  <eval token="selection.latest">'click.value' + (86400 * 3)</eval>
  <eval token="selection.earliest">$selection.latest$ - (86400 * 7)</eval>
  <link...</link>

</drilldown/

0 Karma

PavelNed
Explorer

Hello,

I am not sure if I understand your problem correctly, but have you tried this example?

Solved: Is there a way to zoom in inside a panel and then ... - Splunk Community

It seems strange, because you said you selection.latest x $end$ combination didn't work for you. I used this example and it works, except for resizing of original chart... But that is not your problem, right?

0 Karma

chiliconbeano
Path Finder

PavelNed,

Thanks for taking the time to respond.  Here is a screen shot of my pan/zoom:

chiliconbeano_0-1607687640400.png

Here is my XML (the actual query is URL encoded):

<option name="charting.drilldown">all</option>
<selection>
<set token="selection.earliest">$start$</set>
<set token="selection.latest">$end$</set>
</selection>
<drilldown><link target="_blank">search?q=

| inputlookup my_table.csv
| eval update_time = strptime(day, "%Y-%m-%d")
| where update_time >= $selection.earliest$ AND update_time <= $selection.latest$

</query></link></drilldown></chart></panel>

 

HOWEVER,  when I click on the 'Sept. 24, 2020' data point, the drilldown time value range ends up being the entire range of the chart (Jan. 2020 - Dec. 2020), not the range represented by the zoom frame (Sept. 2020 - Oct. 2020) :

| inputlookup my_table.csv
| eval update_time = strptime(day, "%Y-%m-%d")
| where update_time >= 1579132800 AND update_time <= 1607558400

 

Is there some other <option> setting I need?  According to the documentation, this should be straight forward, yet, I 'must' be doing something wrong.

Again, thanks for helping!

0 Karma
Get Updates on the Splunk Community!

Splunk Search APIを使えば調査過程が残せます

   このゲストブログは、JCOM株式会社の情報セキュリティ本部・専任部長である渡辺慎太郎氏によって執筆されました。 Note: This article is published in both Japanese ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...