Report that shows of average daily transactions year over year

Report for daily shipments and daily Purchase order for the year 2022 and 2023

Created a saved search of type – transaction.

Criteria

( Type is Purchase Order Or
Type is Item Fulfillment ) And
Main Line is true

Result

Type – Group

For 2022 – Formula (Numeric) – Count- CASE WHEN TO_CHAR({trandate}, ‘YYYY’) = ‘2022’ THEN {internalid} ELSE 0 END

For 2023 – Formula (Numeric) Count CASE WHEN TO_CHAR({trandate}, ‘YYYY’) = ‘2023’ THEN {internalid} ELSE 0 END