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 · Accepted solution]

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:

[Aurelien · Accepted solution]

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 🙂

[Aurelien · Accepted solution]

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])

[peterdykstra · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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....