topic Re: How to create a graph using columns and lines in Dashboards & Visualizations

How to create a graph using columns and lines

PabloCarvalho — Mon, 28 Sep 2020 20:13:53 GMT

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.

Re: How to create a graph using columns and lines

yannK — Sat, 13 Jun 2015 12:58:57 GMT

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.

Re: How to create a graph using columns and lines

chimell — Mon, 15 Jun 2015 11:38:08 GMT

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

Re: How to create a graph using columns and lines

chimell — Wed, 17 Jun 2015 07:34:00 GMT

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