How to allow users to sarch from multiple columns in given table visulisation.
I have 6 columns in table and user can search through 2 of the columns from the table.
(table visualisation-type of data visualisation in dashboard, not a report component)
Also, how can we allow user to select top n or bottom n records from this table? (Can dundas reports provide these functionalities ?)
You can achieve this by making use of the different text box filter on the visualization which would have view parameters mapped to the hierarchy to be used for the filtering.
Please see article below for more details
https://www.dundas.com/Support/learning/documentation/create-view-content/filters/adding-filters
For the displaying the top/bottom records in your visualization, you can achieve this by clicking on the pencil icon beside your measure on the data analysis panel to see this feature.
Please see article below for details.
https://www.dundas.com/support/learning/documentation/analyze-data/displaying-top/bottom-records
Hope this helps.
Thanks for the reply. Here for top/bottom we are predefining to select top5 values. can we allow user to select /define the values somehow?
Hi Mitsu,
If you want to allow the user to control the TOP N values, maybe with a slider, you should use a formulas visualization to do this. Here is a quick video of me setting up so that you can follow along.
Hi Jeff!
I have done exactly what you show in the video before and it was very useful. Is it possible so that a user can access the full panel I see to set the top N values? Although that^ works most of the time, it doesn’t change the visualization itself - only the separate formula visualization you have created.
Ideally I want users of my table to be able to select:
Thanks!
