Need help with count of data over time

dennisv24 · 2024-07-26T16:03:31.973Z

Hi,

I’m looking to build a line chart that showcase the count of data per time input, so for example if there are two data values of 10:10 for today it showcases 2, or if it’s just one it shows 1 etc… I’m using the line chart by Bubble but can’t figure out how to group the time inputs to count them up.

Does anyone have a suggestion? See screenshots below…

Screenshot 2024-07-26 at 17.52.12

Screenshot 2024-07-26 at 17.52.18456×586 25.5 KB

Screenshot 2024-07-26 at 17.52.231650×508 20.9 KB

Zeroic · 2024-07-26T16:37:24.786Z

Everything is fine here - except for the Value expression of your Line chart

The value expression currently is Search for Logbooks, which defeats the purpose of grouping. Instead, it should be Current point’s count (the way you have set it up for your label, as Current point’s LogTime).

Let me know if this helps

dennisv24 · 2024-07-26T16:54:15.050Z

I really appreciate your help… sadly when changing the Value expression as mentioned I still get the same result

Screenshot 2024-07-26 at 18.53.121614×682 21.9 KB

Zeroic · 2024-07-26T16:56:26.711Z

Ooh okay. Silly question but did you check your database to confirm that you have multiple entries for the same time (down to the very second, just to be clear)?

dennisv24 · 2024-07-26T17:11:05.632Z

These are the three entries as showed in the line chart, but I don’t see seconds in the entries…
Screenshot 2024-07-26 at 19.10.16

dennisv24 · 2024-07-26T17:26:30.795Z

Well after some testing… I don’t see seconds in the App Data tab, but when just showing them as text on a page you can see the seconds and indeed there is a difference… didn’t knew that this could also be the case, for now I made sure that all the entries round down to the minute and seems to work now…

Thank you for your help @Zeroic, really appreciate this!

Screenshot 2024-07-26 at 19.25.242246×618 9.49 KB

Zeroic · 2024-07-26T17:27:46.099Z

Awesome, no worries. Yeah if you edit the date/time field in the pop-up, you’ll find the seconds there and Bubble counts them differently even if everything but the seconds are the same.

Glad you got the solution though