QuickChart Labels to be dynamic text

[minatoma]

I am facing a problem in quickchart bar graph

the problem is that I want the labels in the x-axis of the bar graph to be dynamically change according to   values in column called letters in diameter table -Diameter[letters], the column type is text

in the below example I want to replace the part

labels:['Q1','Q2','Q3','Q4'] with a dynamic text list from Diameter[letters]

This is the template I am trying to edit

https://quickchart.io/chart?c={type:'bar',data:{labels:['Q1','Q2','Q3','Q4'], datasets:[{label:'Users',data:[50,60,70,180]},{label:'Revenue',data:[100,200,300,400]}]}}

My editing is

CONCATENATE("https://quickchart.io/chart?c=",ENCODEURL("{type:'bar',data:{labels:["&SELECT(Diameter[Letter],True)&"], datasets:[{label:'Polar',data:["&SELECT(Diameter[Polar],[Inspection ID]=[_THISROW].[Inspection ID])&"]},{label:'Ecuatorial',data:["&SELECT(Diameter[Ecuatorial],[Inspection ID]=[_THISROW].[Inspection ID])&"]}]}}"))

Any help?

[Rifad]

Press the 'test' button in the app editor and then copy-paste the result into the quick chart editor just the JSON. What error message appears? The editor should indicate the error by line and column number.

Additionally, try inserting another CONCATENATE() function after the ENCODEURL() function.