Last tested: May 28, 2019
You may be tasked with this kind of question:
“Which are the top 5 states in terms of order count for each month in our history?”
Can I answer this question in Looker and clearly visualize it? Yes, definitely you can! We will solve it with table calculation:
if(${orders.count}>=large(pivot_row(${orders.count}), 5), ${orders.count}, null)
Voila, now you can show this result!
Last but not least, be aware of the column limit in the explore, we have max 200 column limit, however you will start to see warnings of column limit when you have over 50 columns. For the best of performance and story telling, we always recommend less columns for readability of the visualization. For more about row and column limit: https://docs.looker.com/exploring-data/filtering-and-limiting#limiting_data
This content is subject to limited support.