dynamic charting

[johnwiliams]

Hi,

I am want to know that how can we create dynamic charts in file maker pro using web viewer.

plz help me how can i do this in file maker.

[TheTominator]

This technique illustrated by NightWing Enterprises may work for you.

http://www.nightwing.com.au/FileMaker/demos9/demo901.html

Some more options including the one above are blogged here.

http://simoncpage.co.uk/blog/2008/08/15/filemaker-flash-chart-graph-web-viewer/

Edited December 3, 2009 by Guest

[fishtech]

If you have constant network access you could consider the free Google Charts API, starting here: http://code.google.com/apis/chart/

You simply build a URL using your field values which is sent to Google and returned to the web-viewer.

The calcs can look complicated but most of it is just telling Google how you want the chart formatted, ie. colors, line thickness, etc.

For example, the following example takes values from 3 fields:

'xval' (my values on the x axis)

'yval' (my values on the y axis)

'cMovingAv120' (my 120 day moving average field)

and plots the values on a barchart, overlaid with a line chart showing the 120 day moving average:

hth,

ft.

Let(

[

title = "Total";

y = Substitute (List (yval);"¶";",");

x = Substitute( List (xval);"¶";"|");

maxy = Max(yval);

uppery = Round((maxy * .1) + maxy;0);

average = Round(Average(yval);1);

rav = Substitute (List (cMovingAv120);"¶";",")

];

"http://chart.apis.google.com/chart?cht=bvg"

&

"&chds=0," & uppery & ",0," & uppery

&

"&chd=t1:" & y & "|"& rav

&

"&chbh=a&chtt="& title & "+Products+Stocked"

&

"&chxt=x,y,r"

&

"&chxl=0:|" & x

&

"|1:|0|" & uppery

&

"|2:|average (" & average & ")"

&

"&chxs=0,000000,7|2,,9,1,lt,FF0000"

&

"&chxp=2," & ((average/uppery)*100)

&

"&chxtc=2,-500"

&

"&chm=N*0*,000000,0,-1,9"

&

"&chma=30,30,30,30"

&

"&chm=D,0033FF,1,0,1,1"

&

"&chbh=a"

&

"&chs=540x250"

)