How to create a graph using columns and lines

[PabloCarvalho]

Hello,

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?

Thank you.

[chimell]

Hi PabloCarvalho
To solve your problem ,
Firsly :

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>

Secondly :
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

[chimell]

Hi PabloCarvalho
what about the answer above ? Let see if it satisfy you and tell

[yannK]

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.