Limit Displayed Column

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. 

  • I am calculating rate of change day to day across 2 rows
  • sorting based on rate of change results
  • limit displayed rows to show first 5 rows
  • limit displayed column to show most recent date

If anyone have a solution to displaying the columns or a different way of solving this problem, your advise would be a godsend :pray:

1 2 626
2 REPLIES 2

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.

Dawid
Participant V

In the settings of the visuaslisation you have this Data section:

1d4882cc-0b61-463f-b304-e5ea256b84e4.png

There, you can Limit Displayed Rows and show only the first row just make sure your ordering is how you want it:

14463a01-75ea-47ee-92db-b74f73c24d9f.png

If you ever need more, you can create a Table Calculation that returns yesno:

2b998001-e556-4774-9175-7a07884c9429.png

and by clicking on the gear icon of this field, select Hide Nos from Visualisation:

83abbd88-e47b-4b00-9f19-624b9b0fa18e.png
Top Labels in this Space
Top Solution Authors