Google Charts in FileMaker logo

Google Charts in FileMaker

DB Services

Summary

Product Type: Templates

Price: Free

Last updated: 2/21/2018

Language: English

Product website

Category

Use Google Charts to extend FileMakers charting abilities.

Utilize Google Charts in FileMaker to access multiple charts that are not available in FileMaker.

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. Since native FileMaker charting is much quicker and simpler to set up, let’s look at some Google Charts.

Only Available in Google Charts

Geographic
Candlestick
Organizational
Treemap
Gauge
Timeline

Geographic
This chart offers both a quick overview for an entire geographic region as well as discrete values per region. For example, if Finance needs a way to quickly view sales per state, the Geographic Chart can quickly show us that sales in Illinois are the highest. You can then hover over each state to see how much was sold in each.

Candlestick
With the candlestick chart, you can quickly view a range of values along with its variance. It normally shows financial movements in price or cost. In this example, shaded boxes represent a gain and unshaded boxes represent a loss.

Organizational and Treemap
The next two charts help with viewing a tree data structure. First, the Organizational Chart shows a hierarchy of discrete data. Businesses often use this chart to show a literal hierarchy. This chart doesn’t have too many options, but a developer can configure options such as size, color, or clicking on a cell to collapse.

On a treemap, a user can only view one level at a time, but can navigate to each level. Though this graph also maps discrete values, developers can utilize this graph to show a visual summary of values associated with these discrete values.

Gauge
Applications can utilize Google’s Gauge chart for a fun way to show “safe” and “dangerous” values. It offers the quick visuals of a 19th century railway gauge with all the customization one could desire! Developers can set coloring for ranges of values, specify minimum and maximum values, and even utilize animations to make the gauges more life-like. This chart could be used on an executive’s dashboard to show actual revenue versus expected revenue.

Timeline
The last Google Chart I’ll be covering is the Timeline chart. It helps view data associated with a range of time, reducing the amount of headache needed to process historical data. For example, some bands have an impossible amount of lineup changes, but using a Timeline can quickly clear up any confusion (unless you’re AC/DC and have over 10 former members).

Resources

FileMaker products

See how to create, share, access, and integrate custom apps using the FileMaker Platform.

View products

FileMaker Platform benefits

See why developers choose the FileMaker Platform for their low-code development environment.

See benefits