Chart / graph of counts per hour

akalati · 2021-01-22T20:04:07.526Z

Hi all,

I’m trying to generate a chart of a table’s create activity within a day, grouped by hour. I’ve spent hours on it and couldn’t figure out a way to get it done (including trying to use Toolbox plugin’s List Item Expression to build a list of the create dates but always normalized to 00 minutes, and then use that for the chart using a :Groupby).

Any ideas please? TIA!

will_ericksson · 2021-01-26T22:12:55.496Z

@akalati great question.
I’m working on a similar problem now.

Out of interest, which charting library are you using?
Could you create a simple app and share what you have been able to achieve?

I don’t know if this is the best way, but one idea I had looking at your question is:

Create a field in your table for created_hour and populate this with values from 00 through to 23, then use this as your 2nd group by field.

akalati · 2021-01-26T22:48:20.914Z

Small world. I backed out of everything I tried so don’t have anything useful to share. Yeah, I was thinking of doing exactly that but wish to apply the same solution to 5 other date fields, and perhaps do the same also with day-of-week. So I felt silly creating all of those fields in the DB if it can be avoided.

system · 2021-04-02T20:04:07.603Z

This topic was automatically closed after 70 days. New replies are no longer allowed.