Why Not Just Use the Built-In Charts?
The built-in charts that come with FileMaker out of the box are fine. They work well and look pretty good. But they are static. There is no animation and they don’t respond to clicks. There isn’t any way to drill down into data sets or otherwise explore the visualizations. Also, data visualization goes way beyond whats provided by the built-in charts. If we need that extra innovative experience in our apps then we reach for the JS.
FileMaker Interactive Charts
Oh, and download the files here to follow along.
The video is about 45 minutes long. Here’s a breakdown of the sections:
- 31:33–Handling Clicks
- 40:41–Dashboard Possibilities
src in: ?dnt=1
src gen: https://player.vimeo.com/video/287176611?dnt=1Actual comparison
src gen: https://player.vimeo.com/video/287176611
FileMaker Interactive Charting gives us complete control of the chart. Here’s a partial list of elements we can control:
- The type of chart
- Displaying two types of charts in the same graph.
- The labels and their format
- The x-axis categories, their display format, and the number of ticks.
- The y-axis placement (left, right, or both)
- What happens when you click on or hover over a data point.
- The colors of each line or bar or pie segment
- Whether or not grid lines are drawn in the graph
It’s incredible what we can do, and it is fairly easy to set up.
Takes some time
FileMaker C3Charting does take some time to set up, but it gets easier the more times you do it. There’s the data structure and the library files code copying. You have to write in the customization you want and so on. There’s a lot to do, but that’s okay. It is worth the time to get the chart exactly how your client wishes it to be.
With a Web Viewer and with this charting library, you can set up a dashboard. More than one chart can be visible, each chart having different properties. With this library, a dashboard is easy to generate.
We will revisit this
FileMaker Interactive Charts requires a lot more discussion, so don’t think we are done with this discussion. In a future video, we’ll explore how to use JSON as the data that drives the chart.