How to use plotly panel in Grafana?

Grafana Dashboards
, ,
1

My data source is Postgres and my query returns columns min,max,mean,std,q1,median and q3. Now how do I plot these data as Box Plot using plotly panel.

2

Check this docu out

Something like this ?

image
image1105×579 21.9 KB

let jumbo;

data.series.map((s) => {
 jumbo = s.fields.reduce(function ( a, current ) {
      a[current.name] = current.values.buffer;
      return a;
  }, {});

  Object.assign(jumbo, {type: "box"});
  return jumbo;
});

return {
  data : [jumbo],
  config : {
  displayModeBar: true
  }
}

make sure you alias your fields as follows

min as lowerfence, max as upperfence,mean,std as sd,q1,median, q3
3

Thanks @yosiasz , I got that working.

1 Like
4

hello, any details for this one? How to use MySql data for this panel?

1 Like
5

Nothing differen from the above solution