gergplus.blogg.se - Filemaker pro 18 advanced charts removing decimals

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.