Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Charting subsummary data

Featured Replies

  • Newbies

FM11. I set up a report layout with sub summaries. (underlying database is some 6000 records with 50 fields each) Simply a field representing a list of equip types, a field representing an evaluation code (A B or C) and another to indicate the number of the evaluation codes against the equipment type. (simple count calculation to achieve this total count per group) All in a single sub summary part.

This works as expected. If a single equip type has say 5 As, and 2 Bs it is summarised and listed accordingly. eg: Equip Y = 5 x A, and Equip Y = 2 x B displayed as two separate line items.

However, when a graph is initiated, regardless of where it is placed, (trailing grand summary, body or where ever - obviously adjust the sort etc depending on location) the chart will combine the quantity and code into one value under the relevant equip type to which each of the codes may belong.

Based on the above it will give me a single instance of Equip Y with a value of 7 (5+2) and annotate the legend as A (if chart is in a leading summary (first record) or a B (Trailing summary - last record)

The sub summary layout appears to exhibit the data in the required format.

Where have I gone amiss? All other data is being displayed as it should. It is only where the parent equip type has multiple instances of different codes that they are not being treated separately but their count is not being treated separately and they are being combined under a single instance of the parent equipment type in the graph. Not the summary layout.

Any hints greatly appreciated.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.