Chart / graph of counts per hour

[akalati]

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]

@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]

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.