Sign in to follow this  
Followers 0
Papabjoe

Chart using Filemaker Pro

7 posts in this topic

Hello all.

I have a problem that may be a step backwards for most of you. Starting in Version 7, I was an active user and developed some almost sophisticated solutions. Over time, my needs for FM dropped and as a result, so has my expertise.

My new role in my job requires some charting that would typically be done in Excel. However, I am doing most of the data entry and reporting in filemaker 9.

I need to create bar charts and I need a quick way to accomplish this.

My current idea, without upgrading to 11, is to create the summary date I need, export it as an excel file with the command to launch the application once the export is complete.

From there I would manually select the data and create a chart.

Question?

Is there a more efficient way to do this in filemaker 9 for mac? I'm not able to purchase any additional software or plugins. Ideally, I'd like to script it so that it not only exports the data but launches excel, and creates the chart. The reason being is that others in my office, may have to perform this task, and they are less than literate in FM, or excel for that matter.

Thank you for your assistance.

Share this post


Link to post
Share on other sites

Truthfully, the best way to go about it is to upgrade to FM11. Or use a chart plug-in, like fusion charts.

I did, however, created an AppleScript some time ago that sent the data to Excel to chart it then got the chart stored as a picture in FileMaker. Too bad these things break with every OS and software update.

So, back to my original suggestion: upgrade your FM version. That are quite a few new things in 10 and 11 over 9; you'll appreciate them.

Share this post


Link to post
Share on other sites

Thanks, but my issue is that I'm entrenched in an excel only office. My superiors are skeptical filemaker is as neato as I keep telling them it is. Needless to say, authorization to purchase upgrades or plugins is not going to happen. If I can make this work and satisfy the requirement for charts, I can then illustrate how I had to bubble-gum and chicken-wire the solution together. While that may or may be enough to motivate the purchase of an upgrade, I still need the solution. Believe me, if I could buy it, I would.

I will look into fusion charts though. Thanx for the tip.

Share this post


Link to post
Share on other sites

I'm not able to purchase any additional software or plugins.

There are many ways to produce a chart in a web viewer - Google Chart Tools and FusionCharts for FileMaker being just the first two that come to mind.

---

FusionCharts for FileMaker is not really a plugin, and IIRC, it's free.

Edited by comment

Share this post


Link to post
Share on other sites

I agree that using Google Chart may be the way to go. You get much better control over formatting using google than the native FileMaker chart tool.

You can learn how to build a chart using an http call here;

http://code.google.com/apis/chart/image/docs/making_charts.html

put the http code, into a web viewer and that is it.

This week (!) google updated the chart tool, I am not sure if the wizard will help you but check this out too;

http://code.google.com/apis/chart/image/docs/chart_wizard.html

this looks like a great tool!

Jerry

Share this post


Link to post
Share on other sites

There are many ways to produce a chart in a web viewer - Google Chart Tools and FusionCharts for FileMaker being just the first two that come to mind.

---

FusionCharts for FileMaker is not really a plugin, and IIRC, it's free.

Jan 11, 2014.  FusionCharts 'free' is no longer available.

Share this post


Link to post
Share on other sites

I agree that using Google Chart may be the way to go. You get much better control over formatting using google than the native FileMaker chart tool.

You can learn how to build a chart using an http call here;

http://code.google.com/apis/chart/image/docs/making_charts.html

put the http code, into a web viewer and that is it.

This week (!) google updated the chart tool, I am not sure if the wizard will help you but check this out too;

http://code.google.com/apis/chart/image/docs/chart_wizard.html

this looks like a great tool!

Jerry

Jan 11, 2014

Chart Wizzard is removed.  Code Playground is not useful in telling me how to get Google Charts to recognized FM tables.

post-72145-0-09068400-1389494370_thumb.p

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • Session Model Chart Problem
      By shevyshevy
      I am trying to chart data using the session model file from Tom Geist, the chart on the file is supposed to display Sales from the current month, with respect to the status of the sales. (Closed and Open). However, the chart is not actually displaying correctly. I am trying to implement the session model on my database, but this issue of the chart not displaying the accurate data is posing a problem. From the records in the file, the sales have more Open sales than Closed ones, also the current sales for the month of february has no closed sales. . 
      Please can someone assist me .. thanks
       
      SessionModel.fmp12
    • Portal exported to excel spreadsheet only contains one related field once, other fields are empty
      By justakid
      Hi All,
      Sorry if the title is a bit confusing, I wasn't sure how to explain it.
      Basically I've got a layout that contains a portal to another table. abc0198_cpa_v002 and xyz0570_cpa_v0008 are the link to the other table (linked to the table by the first 6 characters)

      the problem I have is when I export this I get the following in Excel. I was hoping that the empty fields beneath abc0198_cpa_v002 would be filled with abc0198_cpa_v002.

      I can get it to work by going to the related table, searching for those records (abc0198 & xyz0570), but I will fall into the same problem when I receive multiple records that relate to the same record in the other table. IE I might receive abc0198_cpa_v002 and abc0198_cpa_v005 etc.
      I hope this makes sense and thanks in advance for any help.
    • Export Records to Existing Excel Spreadsheets, Is it Even Possible?!
      By drdunse
      So the company I am working for just picked up a huge contract with a cruise line, where we are going to be surveying some of their hardware and other equipment, guess who has two thumbs and is the lucky son of a gun to make the database for this project? This guy!
       
      Anyways, I can't really go into detail for legal reasons, but I can explain what I am looking for.
       
      I'm wondering if there is a way to export the records from the database in filemaker to an existing Excel spreadsheet, and the biggest reason this is the route I'm trying to go is, I based the solution that I've build thus far on the spreadsheet deliverable that they had given us at the beginning of the bidding process. There are several fields in this deliverable that have the same name, which in Excel is no problem, but we work with Filemaker lol, so there's that. Anyway, so I have about 5-6 different types of fields that share the same name in the spreadsheet that i cannot allow in filemaker, so I cannot just set up an export to create an excel document, or else the client would most likely be very unhappy with the deliverable that they receive. So i want to know if there is any way to throw all of my records into the spreadsheet that they gave us starting at a specific cell for each of the 8 (I think it was 8) worksheets in the file. haha the more I type and am reading what i type, the more impossible I feel like this would be. 
      Thank you to anyone who can offer some help or insight, it is greatly appreciated!
    • Percentage chart Y axis scale
      By Stu412
      Hi there
      I'm trying to put together a couple of A4 landscape layouts which would show a total of 4 line charts on each, therefore each chart needs to be the same size.
      The data being presented in each chart is percentage data which is pre-calculated, so it's easy to plot onto the chart, the problem is with the crazy spacing that FM assigns to the Y-axis.]#
      I initially created the chart with min and max values of 0 and 100 respectively, but when I resized the chart, it shows (useless) values on the scale such as 16%, 26%, 42% etc.
      Whatever size I choose, I want it to show 0,10,20,30 etc.
      Can FM manage this?
      Secondly, some data series lines look very flat when viewed on a 0-100 scale, so instead I can narrow the scale to say, 40-60 (which I know is where the majority of the data points for that series lay).  Once again I'm faced with the same problem when the highest value on the chart is like, 58%.
      Instead, I'd like it to perhaps go 40,45, 50, 55, 60 or whatever suits.
      Can FM manage this?
      I'm aware the charting function is limited, but surely you must be able to manually set a scale?
      Thanks
       
    • Work and Order Schedule form excel file HELP PLEASE
      By spokowirus
      Hi I’m new in Filemaker, but I see lot of advantages using this solution.

      I have two similar excel one is work schedule and next one is order schedule. I would like to have them in FM. My problem Is to build database which keep the visual and functionality of excels

       
      WORK SCHEDULE:

      The main part of this excel (SCHEUDLE) is connecting dates, workers and type of work to do. I would like to keep the visual form of this excel but it should work as a database. Work to do is editable list of work type. At the upfront you can see date, week day and time start of each shift, colors are pointing different line production (usually there are 2 shifts day/night and we have to lines block line and trey line also there are something like work on empting trays )  Below the main part is dictionary to translate contraction ( OL/K is operator of blocking line, W/PUSTE  is forklift on empty side etc. ) and some extra info about production. I will translate last sheudle and add hole excel here.

      Also I did some pivot table to calculate how often my worker work on each post. It is on GRAF

      ORDER SCHEDULE

                      At this excel we have similar situation. (I need to delete sensitive data I only keep date  from the last month MAY 2016). On the left side you have clients which are extra sorted by type of product they take (BLOCKS /  BULK / TRAY ). At the upfront we have dates months, days, week number, total weekly production by product, total day production by product. Last row (IV) is total season order for each client. The main cell is fill with amount of product to do. I should be something like popup menu with order details ( amount of product, order specification, transport specification I will edit that later on )

       
      Please help me build such SHEDULES, I can’t figure out how to start ? 

      P.S. SORRY FOR MY ENGLISH


      ORDER SCHEUDLE.xls

      WORK SCHEUDLE.xlsx