radar chart in appsheet

[IvanCruz]

Hi There.

I’'ve some data listed below

ID	Name	Actual 1	Actual 2	Actual 3	Actual 4	Target
1	David	90	92	95	98	100

Is it possible to make radar chart in appsheet, based on that data?

I want the result like this

Thanks, for your help

[peterdykstra]

Hi @IvanCruz - there is no native radar chart available in AppSheet today, but I have used QuickChart before to create radar chart images in apps - for example:

[IvanCruz]

thanks for reply @peterdykstra i’m trying to use quickchart.. but little bit confuse to put the data on it.. can you show me the code. please.. ?

I need a dynamic radar data based on ID or name Column

thanks for your help.. peter

[Aurelien]

Hi @IvanCruz

I was interested in doing so, I got it to work.

Here are the steps:

1. Create your own chart template : must have the minimum amount of dataset you expect on your radar

2. Click on “Save as API Template”

3. Copy this part:

Then go in your editor.

3. create a Virtual column (just for explanation purpose…), name it “Radar_API_EndPoint” and paste your endpoint expression

4)create a virtual column that will contain your dataset: I call it “VC_DataSet” and set this expression:

LIST([Skill1],[Skill2],[Skill3],[Skill4])

5. At last: create another virtual column, let’s name it “VC_Radar_Dynamic_Image” (Type : Image) and set its expression with:

[Radar_API_EndPoint]
&“?title=A Dynamic Radar”
&“&labels=”& LIST(“Skill1”, “Skill2”, “Skill3”, “Skill4”)
&“&data1=10,10,10,10”
&“&data2=” & [VC_DataSet]

In the end, this is my table structure:

The table content:

The result:

Good luck

[DEVIMPLOY_Autom]

molá, very cool this tip I will study to be able to use, thanks @Aurelien

[IvanCruz]

HI @Aurelien . Thank you for your solution and instructions. perfectly work in my app..

trying to make it more simple with only one virtual column to add, but still can’t figure it out..

[Aurelien]

Hi @IvanCruz

It will be:

“https://quickchart.io/chart/render/zm-45cbf4b9-759d-4983-94fa-123456789”
&“?title=A Dynamic Radar”
&“&labels=”& LIST(“Skill1”, “Skill2”, “Skill3”, “Skill4”)
&“&data1=10,10,10,10”
&“&data2=” & LIST([Skill1],[Skill2],[Skill3],[Skill4])

[IvanCruz]

hi @Aurelien Yes.. I’ve tried before.. the codes got no error.. but the radar is not appear as follow

[Aurelien]

Would it be possible that the radar endpoint is wrong ? What happens if you copy paste the output of your expression directly in a web browser url bar ?

[IvanCruz]

hi @Aurelien Yes. you’re right.

I was put the wrong quickchart template URL on my expression.

I really appreciate your quick response

the code is work…