Cross Filtering takes too much load time on Looker dashboard. I have a table, when we select a metric to cross filter on the other tile, it takes almost more than 1 minute to cross filter on the other tile. That’s really long for users to analyze and get insights.
1 Like
Hey @Tincy_Thomas
Could you please share what kind of queries are being used to load the data? It would be helpful to understand this in a bit more detail.
This type of issue often occurs in Looker when queries are running on large datasets. To improve performance, you might consider using aggregate tables, blended data, reducing joins and overall query complexity in the Explore, and enabling caching so repeated filters load faster.
1 Like