# calculation help needed for google charting/append variable data based on found count

Question asked by drrehak on Jan 29, 2010
Latest reply on Feb 5, 2010 by TSGal

### Title

calculation help needed for google charting/append variable data based on found count

### Post

I'm using google charts to create a chart based on data in the foundset.  Using webviewer, I have a url such as:

`http://chart.apis.google.com/chart?cht=lc&chs=450x330&chd=t:7,18,11,26,22,11,14&chxr=1,0,30&chds=0,30&chco=4d89f9&chxt=x,y&chxl=0:|Mon|Tue|Wed|Thu|Fri|Sat|Sun&chls=3,1,0&chm=d,4d89f9,0,0,12,0|d,4d89f9,0,1,12,0|d,4d89f9,0,2,12,0|d,4d89f9,0,3,12,0|d,4d89f9,0,4,12,0|d,4d89f9,0,5,12,0|d,4d89f9,0,6,12,0&chg=0,6.67,5,5 where I have substituted my data fields.  the problem is the chart point markers chm=.  I need to specify each marker counting up 0,1,2,3.... in the url abovechm=d,4d89f9,0,0,12,0|d,4d89f9,0,1,12,0|d,4d89f9,0,2,12,0these are the the first 3 markers.  as you can see the 4th character in each marker point goes up +1 for each data point.  (wow this is hard to explain). all the way up to my foundset count.  sometimes I'll have 3 in my foundset, sometimes I'll have 20.  How can I append a series of data to my url (based on the count of my foundset).   I am thinking of how a loop works in a script where you have a variable = n, add 1, loop, exit loop if n=foundset count.  How can I achieve that within a calculation (result is basically text...the url... which is then the webviewer). thanks in advance!!! `