calculation help needed for google charting/append variable data based on found count
I'm using google charts to create a chart based on data in the foundset. Using webviewer, I have a url such as:
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!!!