LinkedIn
Twitter
Hy there,
I needed some kind of sparkline for an application and decided to use SVG image to get it.
I don’t know if it will be the best way, or if anyone has a better solution.
To create the image I used a formula in Gsheet:
Blockquote
=“data:image/svg+xml;utf8,<svg xmlns=”“http://www.w3.org/2000/svg”" preserveAspectRatio="“xMidYMin meet”" viewBox=""-5 -5 118 “&MAX(B7:G7)*10+20&” “” width="“100%”" height="“100%”" >
<line x1="“3"” y1="""&MAX(B7:G7)10&""" x2="“3"” y2="""&(MAX(B7:G7)-((B7MAX(B7:G7)))/MAX(B7:G7))*10&""" style="“stroke:blue;stroke-width:6"” />
<line x1="“23"” y1="""&MAX(B7:G7)10&""" x2="“23"” y2="""&(MAX(B7:G7)-((C7MAX(B7:G7)))/MAX(B7:G7))*10&""" style="“stroke:blue;stroke-width:6"” />
<line x1="“43"” y1="""&MAX(B7:G7)10&""" x2="“43"” y2="""&(MAX(B7:G7)-((D7MAX(B7:G7)))/MAX(B7:G7))*10&""" style="“stroke:blue;stroke-width:6"” />
<line x1="“63"” y1="""&MAX(B7:G7)10&""" x2="“63"” y2="""&(MAX(B7:G7)-((E7MAX(B7:G7)))/MAX(B7:G7))*10&""" style="“stroke:blue;stroke-width:6"” />
<line x1="“83"” y1="""&MAX(B7:G7)10&""" x2="“83"” y2="""&(MAX(B7:G7)-((F7MAX(B7:G7)))/MAX(B7:G7))*10&""" style="“stroke:blue;stroke-width:6"” />
<line x1="“103"” y1="""&MAX(B7:G7)10&""" x2="“103"” y2="""&(MAX(B7:G7)-((G7MAX(B7:G7)))/MAX(B7:G7))*10&""" style="“stroke:blue;stroke-width:6"” />
<text x="“0"” y="""&MAX(B7:G7)*10+10&""" fill="“red”" font-size="“9"” font-family="“Verdana”">"&B7&" <tspan x="“20"” y="""&MAX(B7:G7)*10+10&""">"&C7&" <tspan x="“40"” y="""&MAX(B7:G7)*10+10&""">"&D7&" <tspan x="“60"” y="""&MAX(B7:G7)*10+10&""">"&E7&" <tspan x="“80"” y="""&MAX(B7:G7)*10+10&""">"&F7&" <tspan x="“100"” y="""&MAX(B7:G7)*10+10&""">"&G7&" <line x1="“0"” y1="""&MAX(B7:G7)*10+1&""" x2="“108"” y2="""&MAX(B7:G7)*10+1&""" style="“stroke:rgb(1,1,1);stroke-width:0.5"” /> "
Blockquote
Not the best solution but I didn’t find a way to do it in Appsheet. If anyone can help me, I appreciate it.
The end result is something like this:
Update:
I think using the Google API (deprecated in 2012, but it work) we got a better solution.
https://developers.google.com/chart/image/docs/making_charts
Here is a comparison between the two options, using a virtual column with the formula:
"https://chart.googleapis.com/chart?cht=bvs:nda&chs=180x100&chd=t:"
&[V_0]&","&[V_1]&","&[V_2]&","&[V_3]&","&[V_4]&","&[V_5]& "&chco=0000FF&chm=N,ff0000,0,-1,9,,e::10|o,ff0000,0,-1,6"
I hope it is useful for someone.
You’re welcome @Peter and @Suvrutt_Gurjar . Good thing it’s useful.
I am still learning how to work with Appsheet and have realized that there are so many possibilities that we ended up doing more than we initially anticipated.
The possibility exists, getting it is more difficult. 
