Difference between revisions of "Advanced row filter"
(Created page with "Creates a dinamic dataset that is used as a filter in the object. Question: I want to filter the 10 greater clients by gross sales. For basic row limits, see [[Row limit...") |
|||
| Line 1: | Line 1: | ||
| − | Creates a dinamic dataset that is used as a filter in the object. | + | Creates a dinamic dataset that is used as a filter for the data in the object. |
| + | The data displayed in the object can be different from the columns used to create the dataset. You can create a dynamic dataset that bring the ''ten clients'' with more ''gross sales'' value and see in the object which products these ''clients'' buy. The data of the dinamic dataset not necessarily need to be explicitly shown in the object. | ||
| + | For basic row limits, see [[Row limit]]. | ||
| + | |||
| + | |||
| + | |||
| + | '''Parameters''' | ||
| − | + | * Ordered by: Set the ''Value'' column that will be used to filter the results for the dataset; | |
| + | * Grouped by: Set the ''Text'' or ''Date'' column that will be used to group the dataset; | ||
| + | * Sorted by: Set if the filter of the dataset will get the greater (Descending) or smaller (Ascending) results; | ||
| + | * Limited to: Set the ammount of rows that the dataset will bring; | ||
| + | * Show others: Set if the remaining rows (not contained in the dataset) will be agregated under an ''Others'' row. | ||
| + | To facilitate it's use, think on the parameters as a question: | ||
| − | |||
| + | ''I want to filter the object data by the '''[Limited to]''' '''[Sorted by]''' '''[Grouped by]''' by '''[Ordered by]'''.'' | ||
| − | + | or | |
| − | + | ''I want to filter the object data by the '''[10]''' '''[greater]''' '''[clients]''' by '''[gross sales]'''.'' | |
| − | |||
| − | |||
| − | |||
| − | |||
'''Example''' | '''Example''' | ||
| + | |||
| + | 1) Filter by and show the ''10 smaller cities'' by net ''revenue'': | ||
| + | |||
| + | |||
Revision as of 12:54, 22 April 2013
Creates a dinamic dataset that is used as a filter for the data in the object.
The data displayed in the object can be different from the columns used to create the dataset. You can create a dynamic dataset that bring the ten clients with more gross sales value and see in the object which products these clients buy. The data of the dinamic dataset not necessarily need to be explicitly shown in the object.
For basic row limits, see Row limit.
Parameters
- Ordered by: Set the Value column that will be used to filter the results for the dataset;
- Grouped by: Set the Text or Date column that will be used to group the dataset;
- Sorted by: Set if the filter of the dataset will get the greater (Descending) or smaller (Ascending) results;
- Limited to: Set the ammount of rows that the dataset will bring;
- Show others: Set if the remaining rows (not contained in the dataset) will be agregated under an Others row.
To facilitate it's use, think on the parameters as a question:
I want to filter the object data by the [Limited to] [Sorted by] [Grouped by] by [Ordered by].
or
I want to filter the object data by the [10] [greater] [clients] by [gross sales].
Example
1) Filter by and show the 10 smaller cities by net revenue:
Applies to
Table, Cross Table, Column Chart, Bar Chart, Line Chart, Area Chart, Pie Chart, Cross Column Chart, Cross Bar Chart, Cross Line Chart, Cross Area Chart, Combo (Filter)
