Thank you very much for your reply Pduflot
I see above you say that code above uses HTML syntax.
I have tried your way in Simple XML (my project is limited there - no Javascript/CSS). And furthermore it is a Column chart.
I tried to set the same of what you suggested in XML, I added the y2Axis. SCAN_ID is the sole field/column I want to hide in legend (it produces nothing)
<chart>
<search>
<query>`mc_vln`
| search DB_NAME=$field_db_name$
| stats
count(eval(CTRL_FIND_ID=-1)) as Broken,
count(eval(CTRL_FIND_ID=0)) as Correct,
count(eval(CTRL_FIND_ID=1)) as Finding,
earliest(_time) as SCAN_DT_START
by DB_NAME SCAN_ID
| sort - SCAN_DT_START
| table DB_NAME SCAN_ID SCAN_DT_START Broken Correct Finding
| dedup $field_last_x_scan$ DB_NAME
| head 15
| sort SCAN_DT_START
| fields - SCAN_DT_START
| rename DB_NAME as Database</query>
<earliest>$field1.earliest$</earliest>
<latest>$field1.latest$</latest>
</search>
<option name="charting.chart">column</option>
<option name="charting.axisLabelsX.majorLabelStyle.rotation">-45</option>
<option name="charting.axisTitleX.visibility">collapsed</option>
<option name="charting.axisY2.enabled">false</option>
<option name="charting.axisLabelsY2.axisVisibility">hide</option>
<option name="charting.axisY2.fields">"SCAN_ID"</option>
<option name="charting.axisY2.minimumNumber">0</option>
<option name="charting.axisY2.maximumNumber">0</option>
<option name="charting.axisTitleY2.visibility">collapsed</option>
<option name="charting.axisY2.scale">inherit</option>
<option name="charting.chart.stackMode">default</option>
<option name="charting.legend.labels">["Finding","Correct","Broken"]</option>
<option name="charting.legend.placement">top</option>
<option name="charting.seriesColors">[0xFA4343,0x00579F,0x646464]</option>
<option name="charting.legend.masterLegend"></option>
<drilldown target="blank">
<link>scan_data?form.field_db_name=$click.value$&form.field_scan_id=$row.SCAN_ID$&form.field_ctrl_find_name=$click.name2$</link>
</drilldown>
</chart>
but I does not work, I still see the SCAN_ID field (the only needed to hide) appear in legend menu
Is your solution valid for simple XML, or am I missing something in my code?
Can you please advise at this point?
thanks and best regards
Altin
... View more