MARKETPLACE
PLUGINS
GROUP BY HOURS - LIKE SQL
Group by Hours - like SQL logo

Group by Hours - like SQL

Published November 2022
   •    Updated March 2026

Plugin details

Given a list of dates, group them by hours into a list of counts and fill in the gaps.
Say you have a list of events over 24 hour (logins, purchases, downloads)  and you want to graph how many events happened each hour.  You pass the list of dates in and out comes  list of hour labels and a list of counts - with any gaps in the hour filled in.

Really useful for creating charts where you want to show activity over time. ie time series of events.

Free

For everyone

5.0 stars   •   1 ratings
378 installs  
This plugin does not collect or track your personal data.

Other actions

Platform

Web

Contributor details

Lindsay - Knowcode logo
Lindsay - Knowcode
Joined 2020   •   58 Plugins
View contributor profile

Instructions

1. Add the Plugin element to your page 2. The plugin takes a parameter of a list of dates.
3. Access the lists of labels and values as states on the plugin.

Typically you'd feed these lists into a chart. The service page shows some example of some free Charting plugins and how they work.

Contact me in the forum

@lindsay_knowcode

Types

This plugin can be found under the following types:

Categories

This plugin can be found under the following categories:

Resources

Support contact
Documentation
Tutorial

Rating and reviews

Average rating (5.0)

This is amazing!
December 29th, 2022
With this plugin, you can group data by hour. This is the function that was so lacking in the Bubble. Thanks to the author. It works!
Thank you - much appreciated :-) (plugin author)
September 25th, 2023
  •  
Lindsay - Knowcode
Bubble