How to show hour by hour Chart

jay5 · 2020-12-23T18:37:53.081Z

Dear Amazing Bubblers,

I created 2 apps on Bubble already and I picked it up in the lockdown. Its a wild ride and I am loving it.

Cutting short, I need your help. please.

I have a list of over 2000 applications, each one of them has a created date.

Using the grouped by, aggregated by functions I have been able to see week on week view of applications
created. So I know Monday we got 50 apps, Tuesday we got 55 apps etc.

My problem – how can I create an hour by hour Chart to see 12 apps came at 12 noon, 20 came at 8pm etc.

Something around these lines (see image).

I don’t know how to write any code, so available plugins or using bubble features to do this would be EPIC.

THANKS
Jay

images (11)453×677 40.8 KB

cowontherun · 2021-07-17T01:18:51.907Z

Am struggling to implement this. What would the ‘Do a Search fors’ be for the 2 repeating groups? Are you using ‘group by’ or searching for days/hours? Confused.

jared.gibb · 2021-07-17T01:22:18.176Z

Group results by day and group by hour.

One RG for day data data grouped by day

One nested RG for your data cells data grouped by hour

Aggregate the count.

cowontherun · 2021-07-17T01:26:36.485Z

thanks for quick reply. will try.

cowontherun · 2021-07-17T02:45:06.094Z

This is the only way I could work out how to do it but it’s got too much logic for my liking, am sure there is a simpler way of achieving this. If anyone comes across this forum post and wants to give this a go at making the logic less verbose…

Bubble

Bubble Editor - Hourtest

Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications.