Hi I am looking for a way to limit both the displayed rows AND the displayed columns.
Use case is that I am looking to display the top 5 articles with the highest volatility day to day.
If anyone have a solution to displaying the columns or a different way of solving this problem, your advise would be a godsend
By ‘display’, do you mean a visualization (perhaps on a dashboard as a table?), or an explore? Things you need can be done quite easily if its a visualization.
In the settings of the visuaslisation you have this Data section:
There, you can Limit Displayed Rows and show only the first row just make sure your ordering is how you want it:
If you ever need more, you can create a Table Calculation that returns yesno:
and by clicking on the gear icon of this field, select Hide Nos from Visualisation: