Line Graph Limitations

Question

I wanted to make a line graph of a certain data point, say stock price - over the past 5 years. Plotting days across the X axis, I get an error saying "more than 1000 categories, cant plot"

Anyone ran into this before?

MarkShnierYou · Answer

I don't see it as a published limit, but a limit of 1000 is a pretty common limit with Quickbase for various unrelated features when they need to set a reasonably high but somewhat arbitrary limit when they can't support infinity.

I'm not sure if your stock price example was a real one, but you could group by Weeks instead of by days, and use an average.

Or else maybe you can line up multiple graphs on a dashboard page side-by-side for different time periods relative to the current date. For example, a chart for the current and last year, a chart for two and three years ago and a chart for four and five years ago.

Sign up

Login to the community