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!
@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.
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.
This topic was automatically closed after 70 days. New replies are no longer allowed.