Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Time Bin Intervals

I have searched for a while but only have found solutions using start and end times and recreating those solutions has not worked.

 

What I am looking for is to create a table that on one axis has day and the other axis has time intervals (30 mins) so I can display the number of tickets in each 30 minute interval for every day in a given month. Creating bins using the built in feature carries the date along with it so I end up with a massive table that shows the date with every time interval. I am just looking to have 30 minute bin vs day. 

 

To be a little more clear, the field I am trying to convert is a date + time field. I am using that date + time field twice on the same matrix. One axis being the day of that date time field, the other axis being a 30 minute interval bin of that date time field. While the values are just a count of tickets.

 

Any solutions?

  • Anonymous's avatar
    Anonymous
    4 years ago

    I was able to get this to work simply by splitting by date time field into date and time seperately then using the group/bin function on just the time field.

3 Replies