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
Solved! Go to 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:
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 🙂
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])
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....
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:
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
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 🙂
molá, very cool this tip I will study to be able to use, thanks @Aurelien
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.. 😁
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])
hi @Aurelien Yes.. I've tried before.. the codes got no error.. but the radar is not appear as follow
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 ?
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....
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |