cancel
Showing results for 
Search instead for 
Did you mean: 

I need to get the count of each 24 hour group from the total datetime field

Former Member
0 Kudos

I am looking to get the count for each hour from the total of all entries in the date time field when we group the field by hour.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Hyman,

If you need to create the groups,

one way is to use a case statement like:

Select {Table.TimeStamp}

Case 1: "Group 1"

Case 2: "Group 2"

Default: "No Group"

in a Formula and then create a group on the formula.

then...

Create a new running total.

Select a field to count.

Select "count" or "distinct count".

Evaluate on change of group.

Reset on change of group.

Place in group footer.

Happy Hunting,

The Panda

Answers (1)

Answers (1)

Former Member
0 Kudos

Can you provide some sample data. What are you trying to count, and are you trying to count how many of whatever in one 24 hour period ?