If you do complex data analysis, then from time to time you probably need to group, summarize, and parse data into variables and/or fields. There are various ways to accomplish this, including the Fast Summary technique, which regular readers of this blog may be familiar with, as it has made a number of appearances here […]
Last time we looked at several summary reporting tricks, including a conditional subsummary (when an item’s Status is “Scheduled” it will have a value in the Substatus field — otherwise Substatus will be blank). The challenge was to generate a summary report showing Substatus only where appropriate, without seeing any annoying empty gray rows beneath […]
One of my favorite FileMaker functions is GetSummary; I use it frequently, and it had never occurred to me that there might be any alternative. Recently, however, Mikhail Edoshin pointed out on the FMPExperts list that GetLayoutObjectAttribute can serve as a viable replacement, like so:
Last October I began a series on Outer Joins, which explored a number of different ways to display summarized information in a grid, and at the time I concluded that the “fastest” method was to leverage the FileMaker relational model. And it was plenty fast, locally… and not too bad on a LAN… and technically, […]
Have you ever wished you could pull the values from a summary report, and use them in a script or a calculation? Back in the FileMaker 6 days, Mikhail Edoshin introduced a technique to do just that. He called the technique Fast Summaries, and I came to employ it extensively in my own solutions.
Picking up where we left off in part 1, today we’re going to take a look at examples 2 through 6 in the Virtual List Charts demo file (the demo has been updated since part 1, so I recommend downloading a fresh copy). We covered example 1 and most of the general concepts last time, […]
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. 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 […]
Last week we looked at building a FileMaker 11 native chart based on data that has been parsed into a field-based array. I happen to like field-based arrays, for reasons I’ll get to in a minute, but is a field-based array really necessary to generate the above chart?
In recent postings we’ve looked at… Using a lookup to populate or clear an array (Lookups and Repeaters) Determining the position of an item in a list (ValuePosition) Parsing subsummary values from a found set (Fast Summaries) While these three techniques may not appear to have much in common, all of them are used as […]
[Note 1: as always a huge thank you to Bruce Robertson, for inventing virtual list, and for many other contributions to the FM community over the years.] [Note 2: the following assumes the reader is familiar with basic concepts presented in Virtual List Reporting, part 1.] This is a follow up article to document new […]