Listing only the Top 10 entries in a data set

Overview

SolveXia Analytics & Reporting provides a simple way to create powerful reports based on managed tables. With the latest BI and data visualisation techniques, you can create reports that communicate and inform effectively.

This article will explain how to create a table which includes only the largest ten values from within a data field, along with any other fields corresponding to those values.

Before we get started

Before you start, please ensure that you have a managed table with at least one row of data. If you need help to create a managed table or to import data into a managed table, please refer to the articles below.

For the purposes of this article we will continue to use the example from the How to create a tabular report with Drill-Through capability tutorial.

Steps

1. Create a new Report with the managed table used in the How to create a tabular report with Drill-Through capability tutorial.

2. At the ‘Report Data’ stage, drag, from the Data Field pane into the Columns pane, the ‘AirlineInfo_Date’ field once and the ‘AirlineInfo_Amount’ field twice.

3. Aggregate both of the ‘AirlineInfo_Amount’ fields.

4. Select the second ‘AirlineInfo_Amount’ field.

5. Click the ‘Advanced Function’ option.

6. A new browser window will pop up (please make sure that the ‘pop-up blocker’ of your browser is not blocking pop-ups from the website). The dropdown for function should be set to ‘Analysis’ by default.

7. Scroll down to the ‘Top 10 Rank’ function by clicking on the arrow pointing downwards.

8. Select the the ‘Top 10 Rank’ function.

9. Click the Save.

10. Navigate to the ‘Preview’ stage.

11. Click the arrow at the right side of the header cell of the ‘Rank of AirlineInfo_Amount ‘ column.

12. A dropdown will appear. Select ‘Sort Ascending’ from the dropdown.

13. The table will now be sorted by Rank:

Share
Leave a Reply

Latest Tweets

We are always happy to share good news! SolveXia has received the 2014 Consensus Software Award. bit.ly/1z0sASm #tech #winning #news

reply · retweet · favorite

Subscribe now

News and articles useful to people who are interested in business process improvement. Your details will remain private and you can unsubscribe at any time.

Call today

Australia: 61-2-9386-0202
UK: 44-20-8123-1251
Email contactus@solvexia.com

... ...