πŸ“Š Bar Charts

:bar_chart: Bar Charts Now you can display a bar chart that updates as users make changes in your app. Reply with a screenshot if you add one to your app!

9 Likes

Hi @david, I added a series of bar charts to my app based on user-submitted form data (user logs their daily condition).

The charts go blank after about 35-40 submissions. If I go in and delete a few of the submissions to get it back down to around 30 submissions, the bars gradually reappear - first only partially (see screenshot) and then fully.

Is this a limitation to the chart component? Obviously I don’t expect the chart to show 1000 tiny bars, but maybe grouping by 5, 10 etc as the number increases would be possible, or a line chart for large numbers?

Or the ability to be able to set a limit on the number of bars to show in a chart (sorted by date for example)?

Maybe you could run a query or some other formula in a new sheet to load only the last 30 records. Then use the sheet for your charts.

Thanks @Jeff_Hager

The sheet holds the submissions for multiple users though (this is an app for an organisation where there will be dozens of users submitting each day).

So would it be possible to have a formula that pulled the last 30 submissions for each and every user? Not just the last 30 submissions of the entire group of users in general.

This is an interesting formula. Seems to keep a running count unique to a specific column value. I think this could work if you use a query to load your results into another sheet in reverse date order, then create a new column that uses formula. This will number each row, grouped by user. The most recent dates will have lower numbers. This way you could apply a filter on the numbered column where the number is less than or equal to 30.

=ARRAYFORMULA(IF(LEN(A2:A)=0, "", IF(A2:A=A2:A,COUNTIFS(A2:A,A2:A,ROW(A2:A),"<="&ROW(A2:A)),)))

Originally found here, but modified slightly. Should be able to place in the second row and replace all A2:A columns with the column of your user name (or email):