Scenario: User would like to check the Sales Orders that are created every hour.
This is possible to achieve by creating a Transaction Saved Search with Formula.
Here are the steps we may take:
1. Navigate to Reports > Saved Search > All Saved Searches > New
2. Select Transaction
3. On Criteria, select the following:
- Type = Sales Order
- Main Line = True
- System Notes fields...: Type = Create
- Source = Set any preferred source
4. On the Results tab, check Show Totals and add the following:
- Type
- Document number
- Source
- Date Created
- System Notes fields...: Date
- Formula (Numeric) | Formula = TO_CHAR({systemnotes.date}, 'hh24') | Custom Label = Hour
- Formula (Numeric) | Formula = CASE WHEN TO_CHAR({systemnotes.date}, 'hh24') = 10 Then 1 else null end | Custom Label = 9 AM
- Formula (Numeric) | Formula = CASE WHEN TO_CHAR({systemnotes.date}, 'hh24') = 11 Then 1 else null end | Custom Label = 10 AM
- Formula (Numeric) | Formula = CASE WHEN TO_CHAR({systemnotes.date}, 'hh24') = 12 Then 1 else null end | Custom Label = 11 AM
- Formula (Numeric) | Formula = CASE WHEN TO_CHAR({systemnotes.date}, 'hh24') = 13 Then 1 else null end | Custom Label = 12 NN
- Add the formula for the time range you would want to have
5. Set SHOW TOTALS to checked/enabled
6. Set Summary Type on the following fields under the Results tab:
- Type = Group
- Formula (Numeric) per time range = Sum
7. On Available Filters tab, add:
- Date Created > check Show in Filter Region
Note: What each formula does is, based on the value you set so when a transaction falls into "9 AM", it will return a 1 value in the field. With Show Totals checked, you will be able to see the totals of sales orders created within that hour.
I hope this helps! Let us know your insights in the comments! 😊