Scenario:
Create a saved search that shows the sales that occur within each hour in a day without considering the tax.
Solution:
List> Search> Saved Searches
Select Transactions
Enter Search Title
Criteria:
Type: Sales Order
Status: is not Sales Order: Closed
Date Created: is on Today
Main line: False
Results:
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’00:00:01′ AND ’01:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 00 – 01 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’01:00:01′ AND ’02:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 01 – 02 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’02:00:01′ AND ’03:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 02 – 03 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’03:00:01′ AND ’04:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 03 – 04 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’04:00:01′ AND ’05:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 04 – 05 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’05:00:01′ AND ’06:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 05 – 06 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’06:00:01′ AND ’07:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 06 – 07 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’07:00:01′ AND ’08:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 07 – 08 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’08:00:01′ AND ’09:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 08 – 09 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’09:00:01′ AND ’10:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 09 – 10 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’10:00:01′ AND ’11:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 10 – 11 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’11:00:01′ AND ’12:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 11 – 12 am
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’12:00:01′ AND ’13:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 12 – 01 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’13:00:01′ AND ’14:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 01 – 02 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’14:00:01′ AND ’15:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 02 – 03 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’15:00:01′ AND ’16:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 03 – 04 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’16:00:01′ AND ’17:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 04 – 05 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’17:00:01′ AND ’18:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 05 – 06 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’18:00:01′ AND ’19:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 06 – 07 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’19:00:01′ AND ’20:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 07 – 08 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’20:00:01′ AND ’21:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 08 – 09 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’21:00:01′ AND ’22:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 09 – 10 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’22:00:01′ AND ’23:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 10 – 11 pm
Field: CASE WHEN TO_CHAR({datecreated}, ‘HH24:MI:SS’) BETWEEN ’23:00:01′ AND ’24:00:00′ THEN NVL(({amount} – {taxtotal}), 0) ELSE 0 END
Label: TIME FRAME 11 – 12 pm
Click Save