Data Processing and Analysis
Filters
(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
(Click image to enlarge) |
Create calculated fields, including date and time conversions, using an extensive library of numeric, logical and string functions. |
Sorting Data
Top and Bottom 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
(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
(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
(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
(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
(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
|
Features
