Can row limit be set as a global filter?

As a beginner in Looker,  I’m currently tasked with making the row limit as a global filter.

My goal is that letting users to decide how many rows they want to get on each tile (top 5, top 10 etc) by selecting any number in customized filter.

I tried using `row()` function in table calculation to get the row number, but still cannot assign it as a global-view filter finally.

Is there any workaround such as creating a measure to deal with this, or there is already a solution?

Thanks for the time and help! 

Solved Solved
0 1 745
1 ACCEPTED SOLUTION

Hiya!

You can do this with parameter, which can be a global filter. User there will select the number of rows they want to see, you will compare this number to the row number (or rank) in a table calculation and then use “Hide No’s from Visualisation” for the row_numbers  bigger that parameter value. You can use this doc for guidance: https://help.looker.com/hc/en-us/articles/360023638494-Dynamic-Rank-in-Visualization-Using-Parameter

Cheers! 

View solution in original post

1 REPLY 1

Hiya!

You can do this with parameter, which can be a global filter. User there will select the number of rows they want to see, you will compare this number to the row number (or rank) in a table calculation and then use “Hide No’s from Visualisation” for the row_numbers  bigger that parameter value. You can use this doc for guidance: https://help.looker.com/hc/en-us/articles/360023638494-Dynamic-Rank-in-Visualization-Using-Parameter

Cheers! 

Top Labels in this Space
Top Solution Authors