Monarch forEZ-Pickin'sez-pickinsFeatures

Next Steps
Download a Free Trial
Request a Price Quote
Talk to a Product Specialist:
 630-986-0800
Schedule a Live Web Demo
Get Technical Support
 
Product Info
Monarch for EZ-Pickin's
Features
New Features
Version Comparison Table
Getting Started
How It Works
Product Sheet Opens new window
Print Ad Opens new window
Proven Software
Testimonials
Support
Knowledge Base
Documentation
Installation Instructions
System Requirements
Feature Request
Technical Support Home

Tech Blog
Feedback
 

Data Processing and Analysis

Filters

Filter

(Click image to enlarge)

You can define filters to boil down the data by using filter expressions and functions. Easily switch between filters to get different views of your data. You can also create compound filters, which function as extensions of formula-based filters and help you create longer filters with two or more component filters.

Most report writers include a facility to suppress duplicate values for selected fields. Suppressing duplicate values reduces the amount of visual clutter in a report and helps to emphasize details. EZ-Pickin's also includes this facility, allowing you to suppress duplicate values for any key field in a summary (except for the rightmost key field, which never contains duplicate values).

 

Calculated Fields

Calculated Fields

(Click image to enlarge)

Create calculated fields, including date and time conversions, using an extensive library of numeric, logical and string functions.

Sorting Data

Sorting Data

(Click image to enlarge)

Sort by any field or multiple fields in your table or summary view.

Top and Bottom n Analysis

Top n Analysis

(Click image to enlarge)

Top and bottom n analysis is a common tool provided by data analysis applications. You can create a top n or bottom n analysis of your summary data by sorting the data in the appropriate order then selecting the first n values, whether n is 10, 3 or some other number. These values then represent either the top n or the bottom n analysis.

Query Data

Query Data with Top 10 Analysis

(Click image to enlarge)

Perform queries such as Top and bottom n analysis and by applying filters, sort definitions and by creating summaries.

What If Analysis

What If Analysis

(Click image to enlarge)

With EZ-Pickin's, you can create more complex expressions involving comparisons. This allows you, for example, to calculate a discount only for sales amounts of 75 or more using "IF" statements.

Drill Up or Down

Drill Up or Down Data

(Click image to enlarge)

You can drill down (expand) through summary data to reveal successive layers of detail or drill up (collapse) to view higher level information.

User-Edited Fields

User-Edited Fields

(Click image to enlarge)

EZ-Pickin's User-Edited Fields feature lets you selectively fill in data however you wish, much like a typical Excel column. Easily add your own customized text comments, numeric values, or dates, etc.

Transform Lookup Fields

Transform lookup fields

(Click image to enlarge)

It's easy to transform a value in your report into a new value you want using information from a database file, such as transforming a "Day of the Week" value of 1 - 7 to "Sunday," "Monday," etc., or transforming a Department Number appearing in your report to the correct Department Name.

You can download EZ-Pickin's including the free trial from our public site or on myBCDsoftware.com.

<< Back to Main EZ-Pickin's Features Page