Applies to:
Kyvos Enterprise Kyvos Cloud Kyvos Azure Marketplace Kyvos Single Node Installation
Kyvos Single Node Standard Installation Kyvos Free
TopN and BottomN can only be applied after other filters, showing the top or bottom number of values you specify. It can only be used with dimensions or levels in the current view.
Info
The grand total and subtotals in a crosstab are not updated when you apply TopN. It can only be applied once per dimension/attribute pair.
You cannot modify the criteria in simple and complex filters, such as Contextual TopN, when editing is not allowed from the Sheet and Filter Widget.
Filtering by the top or bottom set of values
To filter by the top or bottom set of values, perform the following steps:
- From the Toolbox, select Workbooks, then select a workbook and worksheet.
- In the Filters pane, click Contextual TopN.
Click the i icon to learn more. - Select a field, choose Is at the top or Is at the bottom, and enter the number of values to display.
- Select a measure to set the order.
- Use the Plus icon to add additional criteria.
Filtering values by TopN in a chart
To filter values by TopN in a chart, perform the following steps:
- From the Toolbox, select Workbooks, then select a workbook and worksheet
- Right-click one of the values in the chart and choose TopN.
The TopN criteria are pre-filled with values based on where you clicked. - You can edit it or add additional filters if needed.
- Use the Plus icon to add additional criteria.
Using parameters while applying topN filter
You can apply contextual topN filters against a measure or a dimension parameter in Kyvos worksheets and dashboards. You can also select dimensions and measure type parameters in the contextual topN filter field so that when the parameter value gets changed, the topN filter field gets updated automatically. With the help of this, you can also update the contextual topN filter field from the dashboard by selecting the new value for the parameter.
- Select a parameter for applying the topN filter.
On selecting a parameter in the topN filter, a parameter quick filter is added automatically with a default value. In this example, we have set it to see the top 10 countries by quantity.
On changing the parameter value from the dashboard, you should be able to see the top 10 countries by discount.
As shown, the parameter selected in the topN filter in the sheet gets replaced by the parameter value from the dashboard.