Hi,
I want to drill down the Gantt/bar chart and store specific colum's value to some token.
For table we can achieve this by $row.<column name$>
. Not sure how to handle it in Gantt Chart. I tried with $click.value$
but its storing the first column data (i.e. _time
) and i want to store UniqueIdentifier
$click.UniqueIdentifier$
is not working either.
Dashboard:
<label>QCST_Tool_DEMO</label>
<fieldset submitButton="false"></fieldset>
<row>
<panel>
<title>Gantt Chart</title>
<viz type="timeline_app.timeline">
<search>
<query>eventtype=mlc_live host=$host_token$ sourcetype=tool_lifecycle | rex field="ScriptName" "^\S+_(?<ScriptName>[^\.]+)\.\S+" | rex field="ActivityType" "^#(?<ActivityType>[^\.]+);" | eval ActivityType=if(isNOTNULL(ActivityType),ActivityType,"NA") | search ScriptName IN (*$script_name_token$*) AND ActivityType = "*$activity_type_token$*" AND Status = "*$status_token$*" | eval ScriptName2=ScriptName | table _time ScriptName ScriptName2 Duration StartDate StartTime EndDate EndTime UniqueIdentifier Status ActivityType | dedup UniqueIdentifier</query>
<earliest>$time_token.earliest$</earliest>
<latest>$time_token.latest$</latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="drilldown">all</option>
<option name="height">399</option>
<option name="timeline_app.timeline.axisTimeFormat">SECONDS</option>
<option name="timeline_app.timeline.colorMode">categorical</option>
<option name="timeline_app.timeline.maxColor">#DA5C5C</option>
<option name="timeline_app.timeline.minColor">#FFE8E8</option>
<option name="timeline_app.timeline.numOfBins">3</option>
<option name="timeline_app.timeline.tooltipTimeFormat">SECONDS</option>
<option name="timeline_app.timeline.useColors">1</option>
<drilldown>
<set token="clicked_value1">$click.value$</set>
<set token="clicked_value2">$click.UniqueIdentifier$</set>
<set token="clicked_value3">$row.UniqueIdentifier$</set>
</drilldown>
</viz>
</panel>
</row>
<row>
</row>
</form>
@agoyal, I have added the post with workaround for Drilldown fix for Second Row of Timeline Custom Visualization, until the issue with drilldown
is resolved: https://answers.splunk.com/answers/588491/cant-drill-down-specific-column-in-timeline-chart.html
@agoyal, I have added the post with workaround for Drilldown fix for Second Row of Timeline Custom Visualization, until the issue with drilldown
is resolved: https://answers.splunk.com/answers/588491/cant-drill-down-specific-column-in-timeline-chart.html
@agoyal, I dont think Custom Visualizations like Timeline support <drilldown>
, so you might have to create your own JavaScript to handle drilldown scenario.
okay thanks @niketnilay
Here is an answer that should get you started: https://answers.splunk.com/answers/471329/is-it-possible-to-drilldown-from-an-status-indicat.html
Let us know if you need assistance.
@niketnilay: you are great !! i 'll try that out. Cheers!! 🙂