Jump to content

Search the Community

Showing results for tags 'charts'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 10 results

  1. I'm creating a reporting section for sales. I'm charting dollar value of sales on a weekly/monthly basis. To accomplish this, I have a list-view layout with sub summary parts grouped by week and a chart in the header which uses the sorted data. The reporting/charts is working as expected, but for weeks where there are no sales, there obviously no data. When I use a line graph, it doesn't necessarily show accurate chronological history. For instance, If I generate a monthly report from January to May and there were zero sales in February, I want to have February item along the x-axis with a zero value. How can I achieve this? I want a calendar as my x-axis values not the dates from my sales tables. Thanks
  2. I am trying to chart and analyze sale data. In particular, "Most popular product(from a specific product category) this quarter/month/year/etc" and things of that nature. In this database there are several tables: I will try to explain how they are linked Sales Order -Sales Order Line Item --Product Product Category -Product --Sales Order Line Item For example, I want to see the most popular product during a certain fiscal quarter do do so, I need to filter the line items by the following criteria and then have a calculation of the sum of found line items grouped by product * order quantity: Based on the tables this criteria needs to be met: SalesOrder::OrderStatus /= "Open" (not equal) (i.e. closed/completed orders) SalesOrder::Year=CurrentYear SalesOrder::Quarter = Fiscal Quarter(or can be month or can be omitted entirely) Product::Category="my category"(whatever) I've tried many solutions and getting somewhat close, but I get stuck with Un-Index-able match fields(keys) dues to calculations from related tables or circular references. Any tips would be great. Lastly, I think I can accomplish the same thing with a script and perform multiple searches against the LineItems based on related tables, but wanted to know if there is a more direct way via the relationship graph. I'm happy to provide more details if needed. Thanks in advance.
  3. 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 and everything that I can think of. This is possible right? Hopefully you can make sense of this. Thanks!
  4. 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
  5. FileMaker offers many different options for charting, but if you need a chart that is not available in FileMaker, you should consider using Google Charts. Google Charts is a free Javascript framework that can be used in conjunction with web viewers in FileMaker to extend your charting capabilities. Learn more here!
  6. We would like to display data from multiple tables in the form of charts on a single layout. Filemaker does not allow this, so I am seeking a work-a-round that is not going to significantly add to the overhead. I have a solution that works. It involves container fields and a script that runs at start up. Unfortunately, this script dramatically slows the start of the database, especially if the database is accessed via VPN while away from work. We are using FMP12 clients on Macs running OSX 10.8 or 10.9, and our database is hosted on a server running FMP12 Server. Any ideas would be much appreciated.
  7. FileMaker Coaches' Corner - Tip 12 - FileMaker and Dynamic Charting Maps - Fusion Charts https://youtu.be/6VHgi1xYN-0 Download the sample file here: http://bit.ly/fmtofusioncharts Get up to speed with the FileMaker Pro 17 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas. Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client server integration. Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution. Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development. RCC and LearningFileMaker.com are headquartered in Santa Clara, CA. http://www.rcconsulting.com/ Please feel free to contact us at support@rcconsulting.com If you want to explore building I.O.S apps for I Phone or I Pad and deploying those out to the Apple App Store. Here is a video introduction to our iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw Looking for FM Starting Point free software download: http://www.fmstartingpoint.com For More Free FileMaker Videos Check out Http://www.filemakerfree.com Visit http://www.learningfilemaker.com for all facets of FileMaker Award Winning Video Training. Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos Please Subscribe While There. Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos Welcome to FileMaker Coaches Corner-FileMaker Consultants-FileMaker Coaching Videos https://www.youtube.com/watch?v=UHlcusp9qHk Playlist https://www.youtube.com/watch?v=UHlcusp9qHk&list=PLjTvUZtwtgBRLb-Hvn5jQRlKDg_7LwX4e&index=1 FileMaker Coaches' Corner-Tip 1-Relationships-Naming Conventions https://www.youtube.com/watch?v=NOEZjGLSmt4 Playlist https://www.youtube.com/watch?v=NOEZjGLSmt4&list=PLjTvUZtwtgBTvdhOTqiuQNsPYp9xwxMmQ&index=2&t=0s FileMaker Coaches' Corner-Tip 2-Portal Filtering-Portal Sorting-FileMaker-FileMaker Experts https://www.youtube.com/watch?v=JJiQ-50Hps8&t Playlist https://www.youtube.com/watch?v=JJiQ-50Hps8&t=0s&list=PLjTvUZtwtgBQ_PdJVmJwaCKwjfGI84J8e&index=11 FileMaker Coaches' Corner-Tip 3-Multipage Invoices-Multipage Printing https://www.youtube.com/watch?v=DSXcIWZebqg&t Playlist https://www.youtube.com/watch?v=DSXcIWZebqg&t=0s&list=PLjTvUZtwtgBQ_PdJVmJwaCKwjfGI84J8e&index=10 50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=KpQqLLDcZ8I Playlist https://www.youtube.com/watch?v=KpQqLLDcZ8I&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_&index=13 Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16 https://www.youtube.com/watch?v=urh8iHOCxkg Playlist https://www.youtube.com/watch?v=urh8iHOCxkg&t=130s&index=1&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Please Comment, Like & Share All of Our Videos. Feel Free to Embed any of Our Videos on Your Blog or Website. Follow Us on Your Favorite Social Media https://www.facebook.com/FileMakerVideos https://twitter.com/filemakervideos https://plus.google.com/+FileMakerVideos/videos Filemaker Pro 17 Training Videos FileMaker 17 Videos Filemaker Pro 17 Video Course #FileMakerVideos #FileMakerTrainingVideos #WhatisFilemaker17 #FilemakerPro17Training #Filemaker17VideoTutorial #FilemakerPro17Videos #FileMakerCoaches'CornerTip12
  8. 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 all well and good, but how on earth do I then get the fill styles to be what I need?
  9. Does anyone have suggestions for the best step-by-step way to integrate D3 javascript charting into FM?
  10. 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
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.