JSON Custom Functions for FM 19.Claris Studio (part 2) – Integration with Claris Pro.Older posts Search Search for: Recent Posts ![]() But what may not be immediately apparent is whether overall she’s doing better, the same, or worse.Ĭontinue reading “Weekly Sales Comparison Charts” → Tagged Array, Chart, FrontTabNames, JoinRepeatingVariable, LayoutID, List, ValuePosition 4 Comments Chart, Level: Intermediate, Version: FM 11 or later Array Charting, part 3 When we look at the weeks individually, it’s clear that Zola Buchanan’s sales figures are mixed so far this year, compared to 20. It consists of an Employee table with 20 records, a Sales table with approximately 40,000 records, seven chart types, and an option to chart weekly amounts either individually or cumulatively. Today’s demo file, weekly sales comparison charts, v3, can help answer these questions. How is our sales team doing now, compared to this time a year or two ago?.Are we on track to meet or exceed last year’s sales totals?.If you are responsible for helping business decision makers analyze data, you are probably familiar with questions like: Well it turns out the technique can be applied to charting as well, and today we have a demo file, Virtual List Charts, that contains six examples: three for Web Visits…Ĭontinue reading “FM 13: Virtual List Charts, part 1” → Tagged Array, Chart, Fast Summary, GetSummary, Virtual List 4 Comments Chart, Level: Intermediate, Version: FM 13 or later FM 13: Column Chart on Found Set, revisited The records in this table will derive their data “virtually”, by parsing it from an array - typically one or more $$variables. We’ve already explored Bruce Robertson’s virtual list on this site a number of times, but briefly, you create a utility table in your solution to facilitate non-standard viewing, reporting, etc., and pre-populate it with “more records than you’ll ever need”. We’ll need more than one because while certain attributes (e.g., chart title) can be set programmatically, others, including type (e.g., column or line), must be hard-coded into the chart object. ![]() Today we’re going to look at applying the virtual list technique to FileMaker charting with the goal of producing a reusable chart “object”, or rather, a series of chart objects.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |