Skip to content

Filtering Results

Every table in Output Report can be narrowed to just the rows and columns you care about, so a large report stays readable.

  • Filter opens a checklist of names; uncheck any you want to leave out. On the Impact Analysis tab, filtering also recalculates the ranking.
  • Columns lets you hide the columns you do not need and bring them back later, and your choice is saved with the model.
  • Search finds a row by name across the whole tab.

You can also sort by any column, resize columns, and copy selected rows to paste into a spreadsheet.

LegacyHow this worked in the previous version

Filtered Statistics allows stratification of data collected in variables - that is, multiple variables collected simultaneously.

What are Filtered Stats?

Looking for SLA? Find out What is an SLA

Let’s use an example. A prominent support center stratifies customers based on Type (5 types), Priority (4 priorities), and Service Level (3 service levels). The combination of these descriptive elements equals sixty (5 * 4 * 3) potential statistics. Each variety has a separate service level agreement. A sub example might be Priority 1, Level 1, for customer type 1 requires that 95% of all calls resolve in less than 90 minutes.

When using variables to report service level agreements above, I would need 120 variables and 120 to track the information required. Using 240 elements to define and collect 60 statistics is not reasonable. Using Filtered Statistics, I can collect all the information to report on all groups, answering the same questions with only four variables. To accomplish this data collection task, the variables Time value, Priority, Type, and Service Level, need to be written simultaneously.

All data used in filtered stats must be collected using the same action statements at the same clock time. All Activities or Routes collecting stats would use the same action logic. An example is shown below:

dl9UaW1lID0gQ2xvY2soICkg4oCTIEN5Y2xlU3RhcnQgLy9JZiB5b3Ugd2VyZSBub3QgY291bnRpbmcgb2ZmIHNpZnQgdGltZSwgdGhlbiB0aGUgZmlyc3QgbGluZSBtaWdodCBsb29rIGxpa2UKdl9UaW1lID0gdl9DbG9jayDigJMgYV9DeWNsZV9TdGFydCAvL1doZXJlIHZfQ2xvY2sgaXMgYSBpcyBwYXJ0IG9mIGEgbW9kZWwgb2JqZWN0IHJlYWNoaW5nIG9ubHkgb24gc2hpZnQgdGltZSkuCnZfVHlwZSA9IGFfVHlwZQp2X1ByaW9yaXR5ID0gYV9Qcmlvcml0eQp2X1NlcnZpY2VfTGV2ZWwgPSBhX1NlcnZpY2VfTGV2ZWw=

From the Filtered Stas dialog, select the main variable to display. All variables collected at the same instant display as potential variables used to filter the main variable.

Clicking on the filter dropdown arrow provides methods to filter the main variable.