Not able to achieve a line graph

[rohit06e2]

Hey friends!

Grafana v11.1.0

I have been trying to implement a line graph through various methods (Tried with trend chart - got error saying values must be in ascending order, tried with other ways just to see no visual)

Attaching the screenshot of my graph as a bar chart:

This is the table view of my data that I am trying to represent as a line:

I am now trying to use a new plugin called business charts and using a line graph in that. When I put in my fields to visualize, I am seeing a blank graph not sure why:

It’s been several hours I have been trying to figure why this is not working as expected, can anyone please point me in the right direction on how do I achieve this? I would really appreciate the help! Thanks in advance

[yosiasz]

It does not seem the data you posted came through clearly

what is your datasource? mysql? or api?

[rohit06e2]

I am using Elasticsearch as the base. This is my base table:

I am trying to achieve this visual:

Thanks for the quick response!

[yosiasz]

using business chart configure things as follows

then add the following code

return {
  xAxis: {
    type: 'category',
    data: ['Perfecto', 'Dulce', 'Gracias', 'Linda', 'Bailar', 'Gosar', 'Dormir']
  },
  yAxis: {
    type: 'value'
  },
  series: [
    {
      data: [150, 230, 224, 218, 135, 147, 260],
      type: 'line'
    }
  ]
};

in the following are

Now this is of course just to get you started. You can get your data to populate using javascript.

Follow this docu for further coaching

Business Charts | Volkov Labs

[yosiasz]

[rohit06e2]

Hi @yosiasz

Really appreciate your quick responses.

I am attempting to use Business Charts as directed and using my own data from Elasticsearch as shown below:

I am then performing a bunch of transformations on the data as shown (essentially to get the fail %):

The final output looks like this in a table view:

I am using Business Charts as you advised and am preparing the line graph as follows:

But eventually, I am seeing a blank graph and not able to see any kind of visualization on my end.

This is the expected graph that I am wanting to see through these transformations and using business charts:

Can you please advise on what am I doing wrong here, or if there are any alternative approaches to what I am wanting my final visualization to look like in Grafana.

Thank you for your continued support!

[yosiasz]

check your data point in your browser console by doing console.log(context.editor.dataset)

that should start giving you hints as to what you need to do.

[rohit06e2]

Not sure, but getting this error:

[yosiasz]

so this is probably a good time to read the docu on business chart on

Business Suite for Grafana | Volkov Labs