Charting

I attempted to integrate the d3.js library into a FileMaker web viewer to display FileMaker data and am coming up with a mostly blank screen. I was following the very cool tutorial by Matt Petrowsky from here: http://www.filemakermagazine.com/videos/beautiful-interactive-custom-charts Anyone able to take a peek and tell me where I went wrong? thanks d3js_attempt.fmp12

I download weather data from a site that gives me temperature, precipitation, etc, by month and year. I import this into a table and create a bar chart by year and month. The month table has one record for each month, 1-12, and a global calculation set to the value of year. I create relationships each year linking by month and the global year field. Then I define a series using this table view. It works great. The problem is, every year I have to modify the month table to add a new year, modify the relationship graph to add a new table view, and modify the chart to add the new series. Tedious. Is there a better way?

I've been able to successfully create the chart below (with tremendous help from comment) - but now have hit a roadblock on how to segregate the data within the month columns. I know I need to set up a series in the Y-axis, but not at all sure how to create this series correctly. The goal is to show all inspections by month, for ALL inspectors, with a stacked bar chart showing how many inspections each inspector completed. I have the chart in a header, the appropriate fields in the body, and a summary field cCount of records in a Sub-summary field when sorted by month. Any suggestions would be much appreciated!

I've recently found a need to chart data in our FM solution, and I'm facing a steep learning curve on charting. In the past, I've almost always been able to find some good training on each new FM subject I explore. But I'm striking out on charting. Most of what I find is close to a decade old, and I know charting has progressed since the early days. Any suggestions on where to learn the basics of charting within FM?

I'm stumped and any help would be greatly appreciated. Image of chart and pertinent settings below. My goal is to group and count the number of inspections by month, bu they all are reporting as individual columns on the graph, rather than being grouped as desired. I feel like I'm close, as the correct data is displaying, just not summarizing correctly. I am working on a small found set of inspections, and have sorted the 54 resulting records by the field _get_month_name, and I have a field set as summary to count the number of records (count of primary ID on inspection). Body part is a Sub-summary when sorted by _get_month_name

Hi all I use a bar chart to visually show the amount of fuel available in tanks. The users create entries as fuel is used which in turn adjusts the data. I want to hide the labels FM automatically adds to charts as my solution already displays this data in another form. The chart is merely a visual reference and I don't needed the added labels. Is there a way to do this?

Hi everyone - I have a portal that consists of many rows - as few as 1 and as many as 50. In each portal record is a field called Tempo, which contains one of six values from a value list. I'd like to create a pie chart consisting of six (or less) slices based on the portal records. In other words, perhaps counting records with Tempo=X and using the result to chart. Is this possible?

Anyway of tidying up so the labels don't overlap?

We have a table with lots of Customer Feedback fields They are fixed fields and contain fixed rating items, Either Excellent, Very Good, Good etc I would like to create a Pie chart which splits it by the Rating, and maybe shows a percentage , so 80% Excellent, 10% Very Good, 5% Good, 5% other Is this possible in Filemaker with the pictured data?

Hi Is there a demo solution available containing dashboards and graphs that's free to download. I'm looking at introducing a dashboard to my database and would like to see one running and how it was set up.

Without using SQL (that i find cumbersome) I would like to create a Pie chart, with a dynamically list of labels (?!) I want to do a small analytics using FM. My App, using the FM API, creates a record putting in the FM field "OSversion" the OS system they run in (that can be various, iOS 9.3, 10.1, 11.2, etc) I am struggling to come up, without looping trough the records, for a calculated field that gives me what i need for the PieChart: that is the total of each iOS version return delimited, no matter how different and how many they could be.. For the labels I can use off course a List from the field "OSversion". But for the totals, I cannot use rela…

APART from using current found set in charting can we filter out to visualise data of the current month data using calculation of a field called "DATE" formatted as 31-dec-19 on x axis using filter func i am getting awkward results

tbl.Products has 3 fields: Ref, Agent and Tagged. A number of Products are tagged for an export. From another layout, I want to chart, using ExecuteSQL, the Count of Ref for each Agent who has Products that are Tagged. So at present I have: X AXIS: SELECT Agent from tbl.Products WHERE Tagged is not null ORDER BY Agent ASC Y AXIS: SELECT Count(Ref) FROM tbl.Products WHERE Tagged is not null GROUP BY Agent ORDER BY Agent ASC So my chart shows an ordered. But what I want to do is ORDER BY the count, which means in the SQL I need to output two fields for each SELECT: SELECT Agent,Count(Ref) AS CountRef FROM tbl.Products WHERE Tagged is …

I have 2 fields that are used to create a simple Bar Chart layout: Customers and Sales. Each field is a list of values I have generated from summary reports using Mikhail Edoshin's Fast Summary technique. Each of the 2 fields contains many values (maybe up to 30 or 40 entries), sorted by Sales. I would like to chart the top 10 Customers (by Sales). How would I use a script to modify the data in each field to keep only the first (or last) 10 values? Thank you.

Hi, I have a layout that includes a chart that totals sales for each month - January to December. There is also a drop down list where I can select the year for the chart to display results. Each time I select a year the scale of the Y axis changes. For example, if maximum sales for a given month in 2017 are $3.9M it will show $4.5M as the maximum value on the Y axis. In 2018 the maximum for a month is $4.9M, so the Y axis changes to show a maximum of $5.5M I want to be able to set a scale for the Y axis so that it does not change. Ideally I could create a variable for the user to preset. As an example, the user could set the maximum at $7M. This way,…

Hi All, I'd like to get a count for how many records were created today, this week, this month, and possibly this year to display on a marketing dashboard (Leads). I've tried a couple different tutorials but nothing is seeming to work quite right (and are a bit out-dated). I'd also then like to chart how many leads were generated today for each program (programs on Y axis, today-count on X axis), but i'm having trouble getting it set up since the counts are messed up. What other details would be important? Thanks!

I am wondering why this database won't chart all the data point (after May 29, 2015). It is an error I found in a much larger database, but I have isolated the issue here. Any ideas? Thanks in advance, Fed Charting Error.fmp12

I would like to create a database for my cabinet shop that contains three fields: I want to use this to better understand and explain how we are performing at certain labor activities. In the movie in my head it kind of looks like attached jpeg. The fields are: ITEM ESTIMATED TIME ACTUAL TIME Is this possible to produce a chart like this in Filemaker?

Hi everyone, I have a simple chart which displays month's totals but some months have no data. I'm trying to adjust the script to set the 'empty months' in the date range to 0. Does anyone know if that is possible? I've attached sample of the script, chart and data. Date range is october, 2017 - current date. Notice there is no March 2018. Can I make that empty year/month 0? Thank you for ideas! I'm unsure whether best to set the $description ahead of time with all 0's then replacing the value or whether I should track the month number as I go and add the 0 when current month doesn't match prior or whether there is a better technique to either approach. …

I need to build a chart that shows quantity and value of categories 1 to 5. I should use the scatter chart? Please see the attach image. Thanks

Good morning. I am having trouble displaying data in a chart - this may be as much about schema and relationships as it is about charts, but here goes... I have a table called "SOAP Notes". This table has about 12,000 records. In this table, two of the fields are Date (a date field - surprise!) and Date_Count field - a calculation field that reads this: ExecuteSQL ("SELECT Count ( \"Date\" ) FROM \"SOAP Notes\" WHERE \"Date\" >= ? AND \"Date\" <= ?" ; ""; ""; Date; Date) This calculation field gives me a count of any given day - works fine. I then narrow down the data to be displayed with a FIND (for example "9/2018" in the Date field), I still ge…

It appears I cannot force a line break in a Category Label of a pie chart using the pilcrow "¶". I just wanted to confirm that, or perhaps find out I'm doing something wrong. I've only included one of the case conditions here, for brevity. The label otherwise is performing as expected. thanks Case ( investments::asset_type_all_weather = "bonds_intermed_US" ; "bonds, US, intermediate term (7-10 year) | TARGET: 15%." & "Target = $" & Truncate ( .15 * $$total_value_g ; 0 ) & ¶ & "Actual vs. target $" & Truncate (investments::asset_type_allocated_vs_actual_US_bonds_int ; 0 ) ; )

Hi All, Please could you assist in how to use chart, scattered with straight lines as in excel? File Maker seems to only have scattered but not the sub section of "with straight lines"

Hi, can anyone help with considerations of my first attempt at charting in filemaker. I hope to show a colum chart (sales v wages) on a weekly basis, with the chart displaying actual data and the percentage wages represent against sales? Thank you for any advise...

I have a chart with 2 series on the X-Axis... I want to show data point only in 1 of my 2 series... When I check or uncheck the option (Show data point on chart) it affect my 2 series... is it possible to hide data point on 1 series only??? (In my example i don't want to see any 1.25)

Is it possible to put more than one chart on a layout showing different things? For starters, management would like to see 3 pie charts of the same data, sorted differently: one to show sales proposals by salesperson, one to show them by contracts staff (person doing the paperwork), and one to show their type (new proposal vs change order). It doesn't seem that I can put charts in portals, so are there other options without plug ins?

i have a business solution that I created 6-7 years ago and it's multi-user db running on amp server on a dedicated mac mini. it's been running my business for years. I've recently added a dashboard tab so that I could view key metrics on my business. I run a business where customers send me their circuit cards for repair. I repair them and send them back. I'm trying to create a simple bar chart that shows how many cards (or records) that I have in backlog which gives me an idea of how much business I have "in-process". I can accomplish this by counting the number of records where the airway bill tracking number field is empty because when this …

Hello all, I have a table with over 2000 records and I need to be able to view all of them on a single screen or sheet of paper when printed. Each record is either a part of one group or one other and I want to be able to show which group each record is a part of. I've attached what I hope to achieve. The example has 40 records per row. I can use conditional formatting to make each record either one color or another color, but I'm not sure how to get all the records to display like this. I though of creating a table with 40 fields per record and assigning each field a binary value. The first record in that table will show values 1-40, the second record would sh…

I have basic chart that has a ugly black line around the border of the chart when any area of the chart is selected. I have go through all of the appearance pulldowns of hover, selected, focus, etc and none of the have black border. The chart itself also does not have a black border. The border only appears when some clicks on the area were the chart is. Selecting it does nothing, but the area that it covers is quite large...not sure how to adjust that. Any ideas on how to get rid of this border? Thanks

I am working on putting a line chart on top of a scatter chart, I select transparency of the line chart background and it does not become transparent, is there something else I should be doing. I am using FM14. The scatter chart will not become transparent either.

I am capturing financial information for 5 companies (probably not more than 5 companies would be needed), that are related to each account in the database. Each account in the database would have a different 5 companies associated with it. I want to graph specific data of all 5 companies and the account on a single scatter chart. I am having problems getting the chart to show more than one companies set of data. I currently have a table for each of the 5 companies, would I be better off to have all of the financial data in one table? If I went with separate tables for each company, what is the best approach to create the scatter graph showing the 5 companies plus the acc…

I have a filemaker 11 file that was converted over to the FM12 format. What was once a nice thick horizontal bar chart is now a hairline because of all the introduced whitespace around the chart. The field size is 42 pts tall by 270 wide. The chart looks fine if I increase the height 4x but since the chart and data need to be in List View for printing/PDF creation, increasing it that much is not really an option. I have no padding on the field and all title and legend font sizes are set to the minimum. Anyone have this issue/find a solution. Thanks

Not sure if this would be charting or relationship thread, so if I made the mistake I apologize. I have a basic questions about which relationship would be faster, or if there is a difference at all in my two ideas. I tried to explain this as best as possible so bear with me. I have a table that is full of temperature readings. there is a temperature record for every second of the day. I need to create a line chart that will display the temperatures over a large period of time. Using a Summary takes a long time when analyzing every second for a period of 2 months etc. So I came up with two solutions... Solution 1 Create a 2 New Fields, IsF…

Is there any reason that my chart will only display up to a certain number of records? I'm trying to plot GPS tracks and I have 21,000 records that represent 8 surveys. When plotting only found sets by survey, the chart still seems to only display up to a certain number of records. When I export the records into Excel and plot, all records get plotted without a problem. I'm using Filemaker Pro 13 Advanced on a Windows machine. Thanks.

Is it possible to chart the following data shown in this sub-summary report. The data is all in one table called financials. I would like to chart the data as though there were three series, one for each company. Is this possible to do? I would prefer a standalone chart but could use in a sub-summary report. The y-axis is the ROS data and the x-axis is the AU data.

Hello The built in chart functions of FM will let us create a bubble chart - basically a scatter graph with 3 data sets. My problem is I'm going to need hundreds of data sets, which is going to result in a lot of overlap. Does anybody know of a solution to this problem? I've looked at 360 Works charts - haven't played with the demo yet - but it doesn't seem like they cover scatter graphs. Thanks in advance. Christopher

Hi, I have a customer who rents storage units. The customer want to see last yeas vs this years utilization where his total units are 87 ( 100 % ). The only issue I am having is that each unit rented, the "End" date is empty. The "End" date only populate when they "Move Out" a customer. Any suggestions how to build a relationship to show each month to include the units that their ending is "IsEmpty" and if they "Moved Out" to include then in all previous months ? It seems like the relationship I have tried to establish cancel out the data due to the "Move Out" date. Here is the graph he would like to use. Thanks

Hi all I have a report based on a 'Services table', and it groups the records by Client_IDF. There is also a relationship between 'Services' and 'Machines' via the Client_IDF field. Within the machines table there is a 'type' field. Within each subsummary section on the report (when sorted/grouped by client_idf), is it possible to have a pie chart that displays a breakdown of the client's machines by 'type'? I have tried every combination for this but can't get it to work. Many thanks

Good afternoon, I have come to a standstill in developing an analysis section of my database. What I want to do is very simple in most database or spreadsheet applications however, it just doesn't seem to want to work in Filemaker Pro Advanced 14. All I want to do is chart the accumulative score for pupils over a period of 17 assessments. The assessment scores are -2 through to 3. So if assessment one is 2 and assessment two is 1 the accumulative total so far would be three. On the graph i want it to show Assessment one as 2 and assessment two as 3. I would like a line per pupil with the Y axis showing score and the x axis showing the assessment. The idea …

Hi can anyone point me in the right direction, I have a database that as a Field populated by a value list, i.e.,: Christmas,Easter,Mothers Day , etc. I want to chart how many records exist of each chosen category. I thought it would be from a summary field using Total of and count but that option isn't available, How do I get filemaker to count the number of uses of the word Christmas from that field , can anyone help please? Thanks in advance

I'm still working on a chart I previously posted about, tracking the up and down cumulative results of 'sessions' over time. Ideally, the chart would begin at the ZERO point on the Y-Axis, and then the first real data-point would move up or down from there. But since I don't have a zero record in the data set, it begins with the first result displayed on the Y-Axis (see image). When I want to make a chart to share with someone, I just create a temporary dummy 'zero record' that sorts to the beginning of the set -- but this isn't ideal (extra hassle, addition of an extra record that isn't really a 'session'). Is there a method for dealing with this? I almost ex…

I am charting sales totals (summary field) from a dashboard for a given date range and I am running into some performance issues when charting my live hosted file especially over a WAN link. Waiting for summary field to calculate is taking forever when using a wide date range. Is there a better way to chart my sales data? See chart. Thank you for any help. Anthony FMP12 Adv. Win/Mac Sales Chart.zip

LS, I find charting confusing. Anyway... My goal is to do a product year over year comparison on how many times it has been sold given a date. Two products can be picked and a reference date will be entered. A product has a date in it so it will be unique. That's why I am comparing two products I found the related table example in the training series and I got it to work. However, the 2016 product comes in the first column and the 2015 in the second. I would like to change that so that 2015 comes first. I've tried sorting the relationship, that didn't work.

I'm learning Filemaker in order to bring over some of my favorite applications from spreadsheets. My first chart is just to learn how to use charting, I'm taking data I record maybe, six times a month when i weigh in at the Gym to create a line chart. Problem is, if i make it into a bar or line chart the x axis only includes the dates where I entered DATA. It needs to include every day of the past 30 so I can accurately see the trends. The only data *points* will be the data I've entered; it would just connect those dots. Here's a 5-month version (as a bar chart) so you can see the problem. TIA for any assistance!

It's been long while since I have did any meaningfull charting just doing a small project that requires a basic chart We have freezer that once a week staff logs the temperature of the freezers. Trying to come up with chart that can map this out effectively: Here are the basic data points Freezer # | Date | Celsius | Week | Staff 21 | 3/20/16 | -25 | 2016-12 | SD Haven't done too much yet but the few attempts I did going thru the relationship to chart just one freezers log the dates converted to numbers tried plotting the temperature over time and all the labels were just a big mess

I have a simple Line Graph showing the cumulative money won or lost over time for a poker player. Each point on the chart is a day's result. Currently I haver the Date as the X-axis value. If I have it label the X-axis with the date, of course, I just get a big smudge across the bottom, since depending on the date ranges of the chart I might have anywhere from 5 to 500 points on the chart. What I really would like to see on the Axis is simply the Year solely on those data points that represent the first Result of a new year, so that we can see the shape of the graph and correlate it with Calendar years. Of course, in other charts, say series of single-calendar…

Is there a way of creating your own color schemes on a chart rather than using one of the existing schemes?

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

I want to install chart plugin on FM pro. I have License of chart plugin. I put the chart plugin file on Macintosh HD/Users/user_name/Library/Application Support/FileMaker/FileMaker Pro Advanced/<version>/Extensions/ but not able to see plugin on FMPro > preferences > Plugins. Please provide me in detail steps for this. Also let me know where to enter the license info.

I own a small retail business. I track our daily revenue results and then summarize the weekly and monthly results. I'd like to compare the monthly results to previous fiscal years on the same line graph. I've searched for how to do this and it seems that there is no (fairly) easy way to do this in Filemaker! This seems odd since this is the kind of thing I would have thought a database could do, and the demand is certainly there if the number of people asking are any indication. Basically I'm looking for the x-axis to contain months (Jan-Dec or first fiscal year month to last, whatever) and have several lines showing the data (revenue, COGS, expenses, etc.) show…

Purpose: Show total number of different items given in date range via column chart. Data entry: User enters a quantity for each item given into separate fields on record, eg. on 1/2/2015 I gave out: apples - 1, orange - 5, pears - 2, bananas - 0 I have a summary field calculating total for apples, oranges, pears and bananas which I have added as separate series on the Y axis and additional fields to limit the found count to dates within the specified range. My question: As you can see, the chart is working to a point. However, I'm unsure what I should put it the x-axis to generate the correct labels. The only workaround I have found is 'show legend', which…

What I have: • A table of Animal. Four records in this example. Three fields: a primary ID (number), a Name (text), and Quantity (number). TheQuantity number field's contents gets changed by users at various, random intervals. • A table of Snapshots. Twenty records in this example. Four fields: a primary ID (number), a foreign key (for Animal), Date, and Quantity. • A script that runs once every 24 hours (perhaps from Server). The script simply looks at the current state of each record in the Animal table (Quantity), then goes to the Snapshots table, and creates one record for each Animal (foreign key), and its currently sampled Quanti…

I am doing a column chart with 6 fields that are in the same record, how can I give each field, bar, a different label on the horizontal axis? Lets say I have sales for 6 years in the same record. 2009 $900 2010 $1000 2011 $1100 2012 $1200 2013 $1300 2014 $1400 I would like to label each of the amounts with the associated year.

Newb here. I have a database of neighborhoods. Each record has the house number (address) for each house in the neighborhood in a repeating field. There is another repeating field with status (no work, in progress, done). I'd like to get a pie chart for each neighborhood showing the percentage of the status field of the three categories. I made a list field for the status field, but I can't get a pie chart showing the percentage of each of the three status categories. Any help appreciated. Thanks, HNick

Is this chart possible in FM? If so, can I get help with creating the necessary data series. Just wanted to see if it's possible before I attack the ESQL. I could put the company choice in a global, but it is of value to compare the company's performance against each other (there are currently 4 companies). chart_sketch.pdf

Is it possible to place a chart inside a portal? I have a very simple bar chart that I am wanting to repeat for each of several records in a portal. Is this possible? It seems like I can only create a chart in the context of the layout not within a portal.

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 …

I have a stacked bar chart based on two records in a found set, one for each year, tracks productive vs non-productive wages. Linear scale with minimum and maximum values set. when I use auto ticks I get 15 values from 0 to 50,000,000 when I select any other value for the number of ticks I get all the labels overlaid on each other at the 0 line. Any suggestions about what I am doing wrong?

Hi, A very basic question and hopefully a very easy one to solve (first time user here). I've graphed some numbers across a year (nevermind the wrong sort order). I can't seem to be able to reduce the space being used up in the following marked areas (see attachment). Arrow #1. Outsides area in the charting area surrounding the graph. Arrow #2. Y-Axis title area Arrow #3. Repeated Y-Axis value. I would like to minimize or completely get rid of these areas so that the graph can take up all the space or most of it. Right now about 40% of the width of the area is used for unnecessary blank space and/or repeated info (in case of the repeated y axis). Any help would b…

I've got a table with raw data in it that contains a data and Grade. I've created two calcualtions also wihtin this table for AcademicTerm, which translates the date into an equivalent school term, the other is a summary field which basically counts the Grade field. I want to chart the grades over time (grades range from 1 to 4)through the use of a line chart. What I've done so far, is through the use of a script, summarise the data (chartdata) into a layout (chartdatasumm) which is based on a temp table where the data gets deleted everytime the script runs. I've then tried to chart this and it kindof works. Chartindiv show what I want (ish) but it has the term repeat…

Hi all, I am new to Filemaker Pro 14 Advanced and trying to separate Manufacturer and Serial Number to show up on two lines on the x Axis of my chart here's my specification with out the quotes "locations_MonthlyTrans_Date::Manfacturer & locations_MonthlyTrans_Date::Serial Number". What I am getting is the Manufacturer name then the Serial Number; what I would like to get is the Manufacturer Name and then right below it the Serial Number, I would appreciate any help. Thank you, MikeB

I have 2 tables. First table is named "Financials" and is related to the customers database by the customer ID. In this table I have a field named "heating_bill". Second table is named "CHART". In this table I have created 10 records and filled out the "YEAR" text field with a year like so: YEAR="Year 1", YEAR="Year 2", up to YEAR="Year 10". I have used the "YEAR" field for my horizontal (X) axis on the chart so that I have one bar per year showing, then in the vertical (Y) axis I have a calculation using case to show the projected heating bill year on year with an 8% increase every year. My calculation is like this: Case( CHART::YEAR="Year 1";CHART::Heating_bill; CHAR…

I upgraded the company from Filemaker 11 to Filemaker 13. We are using Filemaker's built in charts. In Filemaker 11, we had a small 1" long , 1/2" tall line graph, which we used to show a trend. Clicking the chart will go to another layout with a large chart. However in FM13, the line cannot be seen. when I made the graph 2" long by 1" tall, I see the line graph, but I see a lot of white-space at the top and bottom. If these are "fixed" dimensions, it would squeeze in on the actual line. I thought this was the graph title, axis titles, etc. So I made sure the titles were blank. Didn't work. then I changed their fontsize to 1pt. still didn't work. Is there a wa…

I am looking after a modern multi-disciplinary teaching lab where 8 different courses can be taught simultaneously. Current venue management system in place is not suitable for this lab, particularly with the bookings. I am exploring ways to illustrate the total student number by setting up a hourly student number trend curve per day in Filemaker based dashboard so that keep the student number under maximum number. Anyone with experience in setting up such trend curves? I have attached a powerpoint which describes the current data format table (slide 3) and how to convert to a table with hourly based calculation of total number of students across different course per hour…

Hi everybody, after diving into Filemaker rather recently I was amazed how quickly I could yank out a solution for our sales folks, this really is a great tool. Now the only thing I'm having trouble with is charting. More specifically, I'd like to display exemplary projected value increases given different percentages and I'm running into a wall for the first time really. A study shows that there is an average increase of 8,5% on revenue when using our product. Now, I'd like to hand out a column chart accompanying our offers that shows increases at 0; 5; 8,5; 10; 15 and 20% respectively, based on the current revenue. Unfortunately, I can't figure out what to base my x…

Hi, Total Newbie to the forum so I hope I am posting in the correct area - please be gentle with me! I have two charts I am drawing using the XMChart plug in. One is a pie chart and the other is a bar chart, and both of them show exactly the same information. They report on certain types of incident called an NMPI and show the amount of different NMPI types recorded within a given date range. What I want to do is to have the NMPI types be the same colour in both of the charts. I have created a filed with a case statement the says (basically) Case (NMPI type = "1"; 135 50 50; NMPI Type = "2"; 145 88 141) and so on, setting the RGB value for each type of NMPI. Which is…

Hi, I have never had a problem with Excel charting so I think I have the basics down "pat", but I am new to FM charting. In my example, I have 20 records. Each record has a single field called Status which has one of 5 different entries. "Raised", "Scheduled", "Monitoring", "In Progress", or "Complete". I would have thought that drawing a pie chart based on this field would give me a pie chart that is divided into 5 slices - showing the five categories and corresponding record count per category. What I get is 20 identically sized slices. I get the same result from a bar chart. I MUST be doing something wrong. The Slice and Category information both point to the same f…

Just starting to use charting within FM Pro Adv and I've successfully created a pie chart outlining the percentage of employees in different categories. What I'd like to do is change the colours that the different categories appear as on the chart so that for example: Watch - is always Red, Good is Amber and Outstanding is Green. I've looked at the colour scheme and changed this to the default but can't seemt o find a way of then changing the individual segment colours to the colours I'd like as I would in Excel / Access. Is this even possible in FM? TIA

I am tryig to get a line chart to work. If I choose style of curve fitting it pretty much looks like I want; except list dates twice. Can someone please help; I have attached both files. Thanks in advance!!!

Hello, I need a bit of help with my filemaker database. I'm not really good at using Filemaker charting system. I want to display the hourly sales in a chart. So if someone could please let me know a better way of getting totals of the invoices per hour of one day and then displaying them on a chart per hour. so x-axis = 09:00 10:00 11:00 12:00 13:00 ..... y-axis = the totals of the invoices. Many Thanks for you help

Hi All, I stuck with a problem, when I was trying to create chart/graph using Portal data. Please help me. Description: I have four rows in a portal in a layout and I want to create a chart/graph using that four records from the portal. Thanks in advance for your valuable responses. Always... Khurshid Khan

Happy New Year! I've got a Bar Chart, months along the bottom, money on the Y. It works well, it's built on automatic date building and summarising for a KPI dashboard type display in an office. I want to add another summary field, the first one is a 'Projected Sales' figure. The second one is an 'Actual Sales' figure, a third one will be 'Sent Sales'. Because i want to display the three bars on top of each other, rather than by the side, I was planning to build the first one and then cut/paste two on top, changing the colour and field for the Y. That way, the 'Projected' figure is in red, as Sales come in and are entered onto the computer system, they build u…

There is a fine line around bar and column charts and the bars and columns as well. Â Is there some way to make that go away? Â I found an attribute in the inspector panel that made the line around the whole chart go away, but there is still this other line around each bar, column and inside the X and Y axis. Â I've looked at the theme css and xml but nothing I manipulate there makes a difference. Â I have attached an image file that highlights this. Â You may have to zoom in to see it. (see the 1 pt line around the bar and chart) Â Â

Hi All, Attached in excel is a graph I am trying to re-produce in Filemaker. Sheet 1 is the pivot table and graph, Sheet 2 is the raw data as exported from FM. I find charting difficult enough in FM, and am not even sure if FM can produce such a graph? Basically, I'm at a complete loss! Any guidance/assistance would be most appreciated. TIA Rundown of data: count number of instances grouped (i.e 4 x 1 ; 2 x 2 ; 1 x 3 etc = x in 1-7 ) grouped by author; year Graph.zip

I'm trying to create a Pie chart that shows how many "Yes" and how many "No" responses I have in my data. The value of Yes or No is in ONE field across 72 records When I make the chart I get 72 slices (there are 72 records). I appears that I need to summarize the data to have two totals: Yes's and No's. I tried to make a Summary field to do this but how do I express 2 different values? I wrote a script that totals the Yes and the No values into two global variable but I can't assign two values to the Pie chart. I'm missing something easy here....Help ! Jason

I have a database based on Icelandic localization with the decimal as comma and thousands separator as dot. The numbers are formatted to use system settings. I have a column chart to show percentage of defects. I.e I have in a sample count of items = 40. Then I have defects like brown heads = 2. Calculating ratio of brown heads gives me 2/40 = 0.05. When I format it on a layout to show 5,0 percent. To have it in percentage I multiply by 100. When I format it on a layout it shows 5,0 percent. When I show the same number on a column chart it shows 5,0 When I change the localization of the system to USA or Canada system settings and insert the same data with dec…

Hi Everyone, I’m trying to chart the open and closed status of my orders by month and year for a given date range but I’m doing something wrong. I have the chart breaking down by month and year ok but my totals are showing the same for all months and years. Am I missing something obvious? See attached Using FM 12 Adv Win/Mac Thanks Anthony ChartMonthlyStatusRelated.zip

Hi, I've just started playing with chart for a database I've created. The quick chart isn't allowing me to do a count of the records. It's greyed out. The table I've tried on is a simple staff table, sorted by Gender and then produced a quick chart on the gender field. I've also created a layout (report) and based the chart from this but with the same results. Â Am I doing something silly? I've attached a copy of the chart.

Hey guys I have a table with several fields (procedure A, Procedure B and Procedure C, Date of Procedure), each of those 3 procedure fields are populated through a drop down list of menu items. I want to create a bar graph that compared fields A vs B vs C according to date, and I can't figure out how. All of the fields are contained in the same table.

Hi All, Firstly, apologies if i have posted this in the incorrect place - there was no 'newbie' section... I have recently developed a database that is designed to allow technicians to submit safety observations to a database (date/time/location/category of hazard/observation that kind of thing) What i would like is to give management or the EHS team the ability to produce a monthly report on a single A4 (or a dashboard) that contains bar/pie charts with; 1) number of submissions 2) per company 3) numbers open/closed etc etc This is quite simple to do on excel but can't find and advice on how to do it with FM13. Any advice would be appreciated... …

I'm pretty new to using Charts in Filemaker Pro, but I stumbled across the excellent article over at Skeleton Key about how to use ExecuteSQL to create forecasting charts in Filemaker Pro. One of the charts that really caught my eye was the seasonal index projection over time, because it mapped plots of data over multiple years into a line graph with the months contain on the x-axis. After reading through the walk-through and downloading the demo file, I was disappointed to find that they were hardcoding the years of the projection into the y-axis of the chart, which is where I hit a limitation in using the native graphing built into Filemaker. Basically, I want the…

Hi all! I have a database to log patients in a clinic with the following fields: DateSeen PatientNo Classification (Two types of Patients: Private and Charity) Is it possible to create a chart that shows the number of Private patients and number of Charity patients per month in one chart? Thank you so much in advance! ----------------------- And if it's not too much to ask, here's another scenario: I have a parent table PatientProfile with the following fields: DateSeen PatientNo Classification (Two types of Patients: Private and Charity) and a Related table Consults: PatientNo (that relates to the parent table) DateOfConsult ConsultType (InPatient or Outpat…

I have a field in my database called progress. This field for now is a checkbox set that has the choices, “Un Started” “In Progress” and “Complete”. Eventually I want an elaborate way to start determining the progress of certain tasks. For now this is a start to understand the way I will construct it. Is there a way to construct a chart that would take (let’s say) 8 tasks and average there progress field and summarize it to show an average bar of where there over all progress is. So I mean on a scale of 0 – 100 with 0 being “Un Started” 50 being “in Progress” and 100 being “Complete”. I also would like to know if you would have to use a script to show the found set of 8 (…

I am using FMP13 to generate reports for clients of the performance of their online advertising. Just some very basic metrics. I have had no problems getting the parts to summarize the metrics for all ads of a certain type (display, search, etc.). I am also trying to display charts showing a monthly breakdown -- this is where I'm having an issue. The monthly metrics are in a related table, the records of which are created through a portal in the ad campaign editor. My charts are only charting months for the first record of each ad type, not summarizing totals for each month of each ad type as I had hoped. What's the missing piece here? I've tried different parts …

I have a layout that displays a chart of the current found set, the user can choose to copy the chart or export the data to excel for more advanced charting options. It's a simple line chart, temperatures by date taken from two fields. The first data point the symbol is cut off and the last data point is cut off. Seems like it should be simple..... I must be missing something. Below is an example.

Hello, I have been given a project to create pie charts for a co-worker. We are in a K-8 school where she wants to chart her teacher observations and show her staff the data from the observations. So, for instance she wants to see how many 1s, 2s, 3s, 4s, and 5s she is giving for each of her indicators of teacher effectiveness. Therefore, the table we have set up has a record for each teacher and then 24 different indicators. Ideally, we will end up with 24 different pie charts which will show the frequency of which my co-worker assigns each number from the rubric. Now, here's my problem. The pie charts not combining like numbers. For example, one indicator "Engages s…

I am new to filemaker and I would like to do a chart report but I have some issue with it. Here is my question, I have database with several tables that each has a input_date and a primary key (Mobile number) to link to a main account table and layout. . Table A mobile_no input_date Field 1 Table B mobile_no input_date Field 2 Table C mobile_no input_date Field 3 Table Account mobile_no However, how can I create a chart layout such that it will display like this. (Line Chart - Table A) -> I tried to set but it either displaying the graph wrongly or only display 1 input_date. X - Axis: input_date Y - Axis: Field1 (Pie Ch…

I have 2 fields I'm looking to chart, one field is the policy effective date field ex: 1/29/2011, the other field is the total charges for each policy. I've got the effective date on the x-axis and the total charges on the y axis. The problem is, I'm trying to limit the data to each month, example 01/01/2011-01/31/2011, but as it currently stands its showing the data for the entire year, all records. Any ideas? Thanks Matt

I'm trying to make a simple chart to show the number of records (executesql count(*) )present with data in y for each record in x (which is a date). The problem is the chart only shows the count for the first record. How do I get the the calculation in the y-axis to be done for each record in the x-axis? Code: x-axis: ExecuteSQL ( "select distinct Event_Date from Log order by Event_Date asc" ; "" ; "") y-axis: ExecuteSQL("select count("An Event") from Log where Event_Date = ?"; "";"" ;Log::Event_Date) Using delimited data, data source Thanks for your help

This is what I see in my development copy (fmp12): ... and I see this in my runtime.... What is your take on this? I am stumped.... (Notice the only object to shows is my 'insert' date and the print icon....)

I have a table that records defects found on production lines. Record ID: URN Defect: aDefect (bDefect, cDefect, etc) Line: 01 (02, 03, etc) FaultCount: 1 (calculation to set field at 1 to enable counting of fault) I am trying to produce a stacked chart showing defects on the X-axis with the cumulative no of defect occurrences per line stacked on the Y-axis. I have created a report grouped by defect: ADefect Line 01 3 Line 02. 4 bDefect Line. 01. 5 Line 02. 3 And a report grouped by line: Line 01 aDefect. 2 bDefect. 1 Line 02 aDefect. 1 bDefect. 4 To try and produce the graph but I am absolutely stumpe…

Hello Board, I've had two charting problems this week that I cannot solve. I need your help again! So, my Dashboard has a line graph and a bar chart in it. One is a Days chart, showing Sums of data per day and the other is a Weeks chart, showing the same metrics, only summed by Week. I'm doing the building and admin on my PC, and there's a PC in the office, with a big 60" screen attached to it, and the Dashboard being displayed, metrics updating etc etc. This odd layout, which is new last few weeks, on my screen shows the data plotted onto the Bar Chart, but the one in the office, which is connected to the same DB on the same server, does not show the data…

Hello Board, Second Charting problem for me... I have a table, it is populated by a MySQL database. It calculates a larger set of data and then generates and fills these fields: Calculation ID (Auto Incremented) Calculations are done everyday and each 'ID' has a date/time attached to it. Order ID Each Sales Order on our system has data calculated for it Shipping Date A Year/Week number, 201423, for example. So, every record on the table has a CalcID (Currently 1-1239, it will be 1240 tonight) an Order ID and a Shipping Date. What i want to achieve is a line graph, with the CalcID across the X, Shipping Date Year/Week on the Y and then the or…

I'm developing a solution for my own use. I intend to use it to update paper nautical charts. The first problem I've run into is error checking about the boundaries of the charts. I'll input longitude-latitude for each edge of the chart, latitude for the northern and southern boundaries, longitude for the eastern and western boundaries. I'll enter standard longitude-latitude coordinates for the corrections. Then the fun begins. I've figured out how to convert degrees-minutes-seconds to decimal degrees, so I can compare one coordinate to another. So far so good. The first problem I have is error checking: I was happily entering charts, one chart per record,…

Hi there, I am using FMP13 on osx Lion. I am trying to have a pie chart based on three fields of numerical data. I have the slice data working as a calculation using: - List (test::Total ; test::total2 ; test::total3 ) How do I get the Category Labels to point to the field names? So they appear on the key. TIA.

Hi, I have created a graph for viewing on my iPhone. It is supposed to simply look at my DB and plot Body Fat % against the dates entered, to track progress. When I preview, I get a graph for each entry, rather than just the one. I had done a short Tapes Grab to show what I mean. http://usetapes.com/v/a5XdrXs4Ql I am very new to this, so any help is greatly appreciated. Paul

Hi, I have a data set that looks something like the following in a subsummary layout. In each subsummary I can generate a line graph of time vs. value for each patient I am sorted by. What I would like though, is a stacked line graph, taking each of the lines from each of the sub summary sections, and stacking them on top of each other in one graph, with each line representing a patient. Is this possible?? I'm not sure how to proceed. Could someone please point me in the right direction? thanks much in advance. patient 1 sample 1 time = 1 second value = 10 sample 2 time = 2.1 seconds value = 21 sample 3 time = 3 seconds …

I have developed a booking system for short term hire items with a gantt type display showing the days that an individual booking covers. I am unsure of how to move to the next stage which would show more than one booking on the gannt chart which normally shows one month ahead. For the current booking I use a let statement to load a repeating field. Conditional formatting provides the colour bars for the gannt chart. Let([ current_date = Extend( gantt_Start_Book ) + Get ( CalculationRepetitionNumber ) ]; If(current_date < Extend( Book_From ) + 1 ; "Av" ; If( current_date ≥ Extend( Book_From ) + 1 and current_date ≤ Extend( Book_To ) + 1 ; Left( Extend( Book_Ca…

Oh, gosh. Let's say you are a beginner, and that during a spate of cleaning up several external drives that were filling up you relocated remote external container files and you have no clue where they were before you started mucking about because you didn't realize how fussy FileMaker Pro is about paths and such, and, well, suppose your FileMaker Pro solution now can't find any of 10,000+ images stored in the aforementioned container fields. Oh. And you also move the FileMaker Pro file, too. And say you tried all manner of combinations with Manage/Containers and options/Open storage, none of which provide joy. And say you searched this forum where you found quite a b…

I am trying to create a chart that I thought would be so simple...and now I'm down this rabbit hole trying to make it work. I have a database is a record of all our donors. What I am looking to do is create a chart that will display donation info by month on each donor record. I have four tables: Donors, Donations, Correspondence, and a join table called DonorCorrespondence. Donors and Donations are related through the DonorID field. Specifically, I'm trying to set up a column chart in a tab panel on a form view layout of the "Donors" table that will display data from the "Donations" table. The y-axis data is the sum of all donations in a given month by a specific donor a…