Good afternoon, everyone!
I’m trying to create a time-series chart ordered by minute, like this:
But when I try to generate it, I get an error saying there are too many rows.
So I need to limit the number of values on the X-axis to keep the chart readable when working with a large amount of data. Does anyone know how I can do this? There doesn’t seem to be an option for it in the time-series chart settings.
If possible, could you explain the solution step by step?
Thanks for the help!
Hey,
Hope you’re keeping well.
In Looker, the chart will try to render every row returned by your query, so the best way to limit X‑axis values is to reduce the underlying dataset before visualization. You can aggregate your timestamp to a coarser granularity (for example, using GROUP BY with DATE_TRUNC to minute or hour) or apply a filter to restrict the time range. You can also use the Row Limit setting in the Explore view to cap the number of points passed to the chart. This way the visualization receives fewer data points, avoids the “too many rows” error, and remains readable without relying on chart‑level axis limits.
Thanks and regards,
Taz
