Custom Vis hiding categories when Subtotals enabled (hitting 5,000 row limit)

Looker Q&A Looker
, ,
1

I am experiencing an issue where my custom visualization does not display all categories when Subtotals are enabled.

  • The Issue: I have a query that should return 4 categories. When Subtotals are enabled, only 2 categories appear.

  • The behavior: If I disable subtotals, I can see all 5,000 rows across all categories. It seems Looker is hiding the “incomplete” categories that exceed the row limit when it tries to calculate the subtotal.

    • I have the “Increased Row Limit” preview feature enabled.(But its limited to few native vis)

    • I am using a custom visualization.

  • What I’ve tried:

    • Increasing the row limit to 50,000 in the Explore UI manually.(Not applicable for custom vis as per docs)

    • Verifying that the 5,000 rows display correctly when subtotals are off. [1]

Question: Is there a specific way to handle the queryResponse in a custom visualization to prevent Looker from omitting these categories, or is this a known limitation when subtotals hit the platform’s row limits or do we have anyother alternative?

2 Likes