Chart bar formatting oddities: paginated table vs db

Hi Folks!

When using a bar chart, I’ve noticed at times the formatting goes a little nuts with pagination. Almost like it is limiting the number of rows being returned, and then outputting a chart that reflects the rows instead of the groupings, even if there is room in the chart for more bars.

Here’s an example:

Then the next page you’ll get something like this:

I’ve even seen it give you the same “bar” period on two pages with different values, confirming it seems like its thinking in terms of a paginated table and less like an entire db.

Is there a way to think about this differently I’ve missed?

Thanks!

image

What’s your setup for this part? If you have a small page size here, it will paginate the chart.

I had completely misunderstood how to use that setting. Thank you!!

1 Like