You don't need a plugin for good charting; there are a million good and free charting js libraries around that you can use in the web viewer.
This one uses C3 I believe:
1 of 1 people found this helpful
Would be nice if you could have your data this way:
Sonya 222 100
Fred 321 1558
I believe I tried that and ran into issues with the query for the axes labeling (via SQL) and then data display (also SQL).
I don't see the problem.
First query the people table and get Name and ID;
Establish the year range in data by getting Min and Max
loop on years with $y
loop on people with $p
build the $y list of all ppl
you will end up with n+1 lists, 1 for ppl and n for years, each one having as many elements as different ppl you have: $totp
loop on $i from 1 to $totp
$result = List($result; GetValue($people; $i) & char(9) & GetValue($list1; $i) & .... )
and you will have the matrix in the $result var.
This is an example of what I was trying to do in FMP.
The graph below is from some code in Java FX (sadly, Java FX doesn't "easily", to say the least, support showing the data value on the graph like FMP does so nicely).
Trying to combine two fields in the SQL, though it works fine in the Data Viewer gives me a blank bar chart in FMP.
Sadly, (it appears that) you didn't read the title of my posting...
sadly you did not see that the first word I used in my last reply was "sadly"...
Sadly, I didn't know what you meant by "sadly"...
In any case, there is no money in the client's budget for plug-ins. I was doing this graph as a favor for them and they don't even know I'm using FMP.
Thanks for your replies!
Hi, here is my solution (might be a bit of a kluge), but it allows you to graph data very easily. Use the data entries called "Scale" to place the scale intervals correctly (I did it for 50 and 100). Use the multiplier to scale the bars for nice display. For the bar itself, I used 2 fields with a slight offset, so that there are no white spaces inside the bar. You can create the template bar using any char, font, size and color. Hope this is useful. -Michael
Progress_bar.zip 78.1 K
I'm amazed, but not surprised, by your excellent and insightful replies on the forum!
Your suggestion here was another perfect solution. Works perfectly!
I'm a bit embarrassed to admit I didn't think of an intermediate calculated field to overcome this issue.
Thank you VERY MUCH!!!!
Be careful, plug-ins don't work with FielMaker Go, FileMaker scripts will work everywhere.