I have three information, total (is my target), reached, and percentage of reached.
I'm trying to create a graph using column (with TOTAL) and line (with PERCENTAGE OF REACHED), but I can't.
The search is "internal_data | timechart count as TARGET, count(eval(type="d")) as REACHED | eval %_REACHED=((REACHED*100)/TARGET)"
_time | TARGET | REACHED | %_REACHED
6/10/15 | 3 | 3 | 100
6/11/15 | 8 | 8 | 100
6/12/15 | 24 | 24 | 100
Can someone help with this using a simple or advantage XML?
To solve your problem ,
Copy and paste the following xml code in a view and save
<dashboard> <label>your_view_name</label> <row> <panel> <chart> <search> <query> index=_internal| timechart count as TARGET, count(eval(type="d")) as REACHED | eval %_REACHED=((REACHED*100)/TARGET)" </query> <earliest>0</earliest> <latest>now</latest> </search> <option name="charting.chart">column</option> </chart> </panel> </row> </dashboard>
Configure your chart in the oder to have a Chart overlay
1- Click on edit tab then check edit panels
2-Click on , check chart overlay then fill Overlay field by %_REACHED field. In Scale
field click on Linear tab
3- Save the configuration and click on Done
If you want a columns graph, with a line overlay, check the graph options in the simpleXML UI editor.
as long as the column exists in the result set, you can specify one of the series to be a line.