Pareto chart without using plotly (combine line and bar charts with no time information)

[lpinho]

I’m using a self-hosted Grafana v8.4.3 running on Windows 10.

I’m trying to build a Pareto chart without using Plotly plugin (combine a bar and line chart)

To start I’ve created 2 different datasources, one for the bar information (number of defects grouped by defects type) and another for the line chart (percentage of the current bar represent + the sum of all previous percentages).

Being a first time user of Grafana, I though this was something easy to do, select one type of chart for each datasource and then combine using a common value (on this case, the type of defects)

I created the 1st datasource, set Format as to Table and set the chart as a bar chart.

Everything look good:

Then I added the 2nd datasource and an error appears:

Log:

logger=token t=2022-05-04T14:21:57.35+0100 lvl=dbug msg=FeatureEnabled feature=dspermissions.enforcement enabled=false licenseStatus=NotFound hasLicense=false hasValidLicense=false products=“unsupported value type”
logger=datasources t=2022-05-04T14:21:57.35+0100 lvl=dbug msg=“Querying for data source via SQL store” id=45 orgId=1
logger=query_data t=2022-05-04T14:21:57.35+0100 lvl=dbug msg=“Processing metrics query” query=“unsupported value type”
logger=query_data t=2022-05-04T14:21:57.35+0100 lvl=dbug msg=“Processing metrics query” query=“unsupported value type”
logger=context t=2022-05-04T14:21:57.65+0100 lvl=info msg=“Request Completed” method=POST path=/api/ds/query status=200 remote_addr=[::1] time_ms=302 size=1701 referer=“http://grafana.staged-by-discourse.com/d/56J7nd_7k/building-pareto?orgId=1&from=now-24h&to=now&editPanel=4&tab=query”

So, my questions are:

• Is it possible to achieve this kind of combined charts without using plotly? How? (all the example that I’m able to find are using time series, I want the x axis to be the defect name, not a timeline)
• How can I understand the source of the error (unsupported value type)

Results of both queries are 7 rows:

17590 contamination
10175 stress
8881 eletric damage
7946 scratched
6530 short
5516 burn
1166 water damage

and

30.421200	contamination
48.036400	stress
63.391500	eletric damage
77.110800	scratched
88.470100	short
97.978600	burn
99.999600	water damage

Thanks for all the help,
LP

[lpinho]

Using a single datasource with the combined information of both datasources, I’m able to produce bar chart but with the information side by side:

Now, I just need the 2nd column to magically transform itself into a line
In the field override I’m not able to find anything that would allow me to do this.

Once again, thanks for your help,
LP

[grant2]

Can you use an Override to change the blue column to a line (something like this, except I did it with the red dataset)?

[lpinho]

Hi @grant2,
Thanks for your reply.
Although I’m able to do that in a time series chart, my data doesn’t have any time information so I’m using a bar chart, and when I get to the override section, I don’t have any Graph Style to override.
I’m using plotly panel plugin as a workaround but I would like to have all the required charts created with the native charts.

Thanks again for your help,
Luís Pinho

[isaozler]

Hi @lpinho did you try Pareto Chart plugin for Grafana | Grafana Labs plugin?

[lpinho]

Hi isaozler,
thanks for your reply, since I had to present to my customer a solution by June, I ended up using plotly to build a Pareto chart.

When we do a review of the product I will try to use that chart.
I don’t remember if I tried it before and got some problem or if for some reason I didn’t found it at the time I was building the dashboard.

Thanks for hint,
LP