I have a dashboard with which I have to select a month token.
On this dashboard I have a graph which shows a Customer against Efficiency (£).
When I click on one of the Customers on my graph I want it drilldown to a new dashboard.
On this new dashboard I want the month token I already had to be passed down but also populate a Customer token.
The Customer token should be populated with the customer that I selected on the graph.
So effectively:
Month token --> (new dashbaord) --> Month token
Customer on graph --> (new dashbaord) --> Customer token
The XML for my Customer v Efficiency graph is below.
<panel>
<title>Customer Efficiency</title>
<chart>
<search>
<query>index="commercial_performance" $month_token$ Cat1="Efficiency Variance *" Value!="within *" | eval Efficiency=round('Value',0) | stats sum(Value) AS Efficiency by Customer | sort + Efficiency | eval Efficiency_G=if(Efficiency>0,Efficiency,0) | eval Efficiency_R=if(Efficiency_G=0,Efficiency,0) | table Customer Efficiency_*</query>
<earliest>0</earliest>
</search>
<option name="charting.chart">bar</option>
<option name="height">550</option>
<option name="charting.fieldColors">{"Efficiency_R":0xFF0000,"Efficiency_G":0x73A550}</option>
<option name="charting.axisY2.enabled">undefined</option>
<option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
<option name="charting.axisLabelsX.majorLabelStyle.rotation">-90</option>
<option name="charting.axisTitleX.visibility">visible</option>
<option name="charting.axisTitleY.visibility">visible</option>
<option name="charting.axisTitleY2.visibility">visible</option>
<option name="charting.axisX.scale">linear</option>
<option name="charting.axisY.scale">linear</option>
<option name="charting.axisY2.scale">inherit</option>
<option name="charting.chart.bubbleMaximumSize">50</option>
<option name="charting.chart.bubbleMinimumSize">10</option>
<option name="charting.chart.bubbleSizeBy">area</option>
<option name="charting.chart.nullValueMode">gaps</option>
<option name="charting.chart.sliceCollapsingThreshold">0.01</option>
<option name="charting.chart.stackMode">stacked</option>
<option name="charting.chart.style">shiny</option>
<option name="charting.drilldown">all</option>
<option name="charting.layout.splitSeries">0</option>
<option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
<option name="charting.legend.placement">none</option>
<option name="charting.axisTitleY.text">Efficiency (£)</option>
<drilldown>
<link>https://146.105.85.57/en-GB/app/Commercial/second_level_customer_dashboard</link>
</drilldown>
<option name="wrap">true</option>
<option name="rowNumbers">false</option>
<option name="dataOverlayMode">none</option>
</chart>
</panel>
You can see the link of the dashboard I want to drilldown to above.
Hopefully I have explained this well enough. Any questions don't hesitate to ask.
... View more
