Hi everyone, Has anyone been able to sort the values in a bar chart eCharts dashboard? I’m using the Infinity plugin, getting information of MITRE Tactics from an API, grouping and summarizing by tactic, and when I try to sort the values obtained using a “sort by” transformation, in a table it sho…

@alejandroguida I did not realize, that order returns the positions of the elements when elements are moved to source.buffer. Here is an example: Set array with order identifiers. Set array with values. Get ordered values for each array. Let me know if it works for you. let names = []; let amou…

@alejandroguida Take a look at the screenshot. Some transformations are changing data frames. You can display the returned data using console.warn(data) and then check whats inside. The values are in the values.order instead of values.buffer, which we provide in our examples. [Screen Shot 2023-0…

Hi @mikhailvolkov , thanks for your explanation. My question then is how can I sort the bars of this new returned data from max to min (I tried again on the code of the plugin with sort function, on the data series and on each axis, with no luck), and additionally and more important, how can I add/…

Amazing @mikhailvolkov , worked perfect: [imagen] Thanks for all your help. Regards, Alejandro

A tip for anybody that read this post and is using Grafana 10 now: The values.order array is not exist anymore in Grafana 10 when you use “sort” transformation. Now Grafana return directly the values sorted, so you don´t need to create namesOrder and amountsOrder series like the example, with names…

@alejandroguida That’s great! Thank you for sharing.

Hi everyone. I wanted to confirm (fairly related to this post) that echarts don’t work when you apply grafana transformations. I get black charts when I have transformations applied. Is there a workaround? [image]

@badikipiten It works. Grafana 10 introduced breaking changes for values.buffer and transformations. More in the documentation and release blogs. [image] Data Sources | Volkov Labs Apache ECharts Panel, as well as Grafana, supports various data sources that you can use to query data f…

Can you assist. This is my json structure. I’m trying to get the hang of getting a basic chart to show and with transformations it doesn’t. We’re running grafana v10.1.5 [Screenshot 2023-10-23 at 22.58.46] [Complaints Category>>Complaint Category] [image] This is what we’re trying to achieve. […

@badikipiten Check the returned JSON structure and parse it accordingly: console.error(data.series);

[image] mikhailvolkov: console.error(data.series); This is my structure: let names = ; let amounts = ; data.series.map((s) => { if (s.refId === ‘A’) { names = s.fields.find((f) => f.name === ‘Complaints Category’).values.buffer || s.fields.find((f) => f.name === ‘Complaints Category’).v…

Sort the bar values in a Bar Chart of eCharts Panel from max to min numbers

Grafana Dashboards

badikipiten October 23, 2023, 10:04pm 17

Dummy Data.
When “Group by” is disabled

When “Group by” is enabled

When Organise fields" is enabled

Topic		Replies	Views
Sort bar chart to display highest values on the top Dashboards	9	14610	January 23, 2025
Apply numeric ordering to fields (dynamically) Dashboards transformations	3	629	March 20, 2024
Bar Gauge Panel - New feature suggestion Grafana Plugin Development	2	503	August 26, 2020
Sort bar gauge by value of expression Grafana bar-gauge , expressions	5	1433	December 12, 2024
Sort results in bar gauge not working (prometheus metrics) Bar Gauge Panel templating , query-help	1	794	June 2, 2024

Sort the bar values in a Bar Chart of eCharts Panel from max to min numbers

Related topics