Trending gives you the power to find hidden, yet important, patterns in your data.
Quick Facts
You perform a trend by selecting a column, right-clicking it and selecting: Trending | ...
You specify your Trend using business language
Once you apply your Trend, you will see the results immediately
You can undo your trend by pressing the Undo button
You can modify the columns in the Trend by using Quick Calculations or Edit Calculations with the Editor
Each trend has common options explained below
- This section discusses many of the Calculation Columns that let you transform your data into the format you need
Common Trend Options
The dialog box for each trend operation has the following options in common:
Option | Effect |
---|---|
Show summaries only | Default checked. When checked, the resulting trend will collapse all groupings to the summary level (thereby hiding the detail lines). When unchecked, the Trend will show summaries and details. |
Hide unused columns | Default checked. When checked, the Trend will hide any column that does not have a filter and is not a part of the Trend. When unchecked, the Trend will not hide any columns. |