Skip to Content

WebI Trick: Top N data for any integer N using Entry field Input controls

There are some discussions about selecting top N data recently. I have been haunted by the idea. In this post, I will show you how to choose top N data using input controls without building extra tables. In addition, you can specify any integer value for N to see the top N data.

I utilize eFashion Universe for demonstration purposes. I also am assuming that you are somewhat familiar with Webi 4.0 – Rich Internet Application Viewing Mode.

Step 1: Build a Webi report using eFashion Universe

/wp-content/uploads/2014/02/step1_389938.png


Step 2: Create a new variable (Rank) to show the ranking of sales revenue in the table

/wp-content/uploads/2014/02/step2_390008.png


Step 3: Sort sales revenue in the table from the highest to the lowest (descending)

/wp-content/uploads/2014/02/step3_390009.png


Step 4: Create a new input control on variable Rank to show top N Sales revenue

Choose variable Rank as an object to filter data. Then click Next.

/wp-content/uploads/2014/02/step4_390010.png


Define the input control as shown in the picture below. Click Next.

/wp-content/uploads/2014/02/step4_1_390011.png


Select the report element to use with the input control. Click Finish.

/wp-content/uploads/2014/02/step4_2_390012.png


Now enjoy the result.


Top 3 sales revenue by SKU desc

/wp-content/uploads/2014/02/e1_390013.png


Top 5 sales revenue by SKU desc

/wp-content/uploads/2014/02/e2_390014.png


Top 10 sales revenue by SKU desc

/wp-content/uploads/2014/02/e3_390015.png

Thanks,

Huu Nguyen

11 Comments
You must be Logged on to comment or reply to a post.