Showing results for 
Search instead for 
Did you mean: 

Ranking by top 10 in Widget

8 - Cloud Apps
8 - Cloud Apps

I have a dashboard widget that displays a Column Chart. I only want to show the top 10 highest amounts within the chart and also rank from highest to lowest (left to right). 

I added a filter and brought in the data that I want to rank by. It pulled in the top 10, but they are in no particular order. 

Thank you. 


10 - ETL
10 - ETL

Hi @KHConsult ,
You can set sorting for your value here:


Always here to help,
Angelina from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner

7 - Data Storage
7 - Data Storage

Hi @Angelina_QBeeQ ,

how should I filter for Top N in case my dataset is already exceeding the shown 10k limit? In this case I run into high memory consumption on a specific widget.

Where would you suggest should I reduce data for the widget (I can't do this in the CUBE) and reducing the timeframe by filter doesn't help and filter relationships only seem to work on dashboard filter.

Thank you