Dynamic Top N Filter

#1

I have a table set up in one of my dashboards made up of 5 different columns. As someone who is editing the dashboard I can set up the table so that it shows the top (or bottom) N rows based on any of the 4 measures in the table. I would like to add this option for a user of my dashboard so that they can choose:

  1. How many rows to display
  2. Either the top or bottom values of the rows
  3. Which column to sort by top or bottom values

I have seen something similar using a formula visualization to dynamically adjust how many rows of records to show - but this cannot change the displayed information for multiple columns at once.

Thanks!

#2

Hi Pierre,
Thank you for writing to us. Your use case can be implemented using Javascript APIs. I would highly recommend you to look into the following article:
https://www.dundas.com/support/learning/documentation/create-view-content/interactions/using-the-script-editor

  1. How many rows to display? - Create a text box component to get the user input value and you need to use the Dundas Javascript API.
  2. Either the top or bottom values of the rows - You can create a radio button set and then pass that value to a script that uses Javascript API to modify the underlying metric set
  3. Which column to sort by top or bottom values - For this you can use the dropdown list box component and then use a script when value is changed event.

Here are the following articles that will be helpful to implement your use case:

  1. Samples and Script Library https://www.dundas.com/support/developer/script-library/
  2. Components - https://www.dundas.com/Support/videos/dashboard-components
  3. Dundas JS API - https://www.dundas.com/support/api-docs/js/

Please let us know if you have any more queries. Thanks.