Sales Per Hour Per Day Saved Search

Answered

Hi,

 

I have been trying to figure out a saved search I need to report how many sales per hour, per day. Is this possible and how might I achieve such a saved search?

 

Thanks

Rookie Asked on June 22, 2020 in Saved Searches.
Add Comment
4 Answer(s)
Best answer

Create a transaction saved search, including  Main Line = True

Add a Formula(numeric) row for each hour when you want to report

CASE WHEN TO_CHAR({datecreated}, ‘HH24′) = ’01’ THEN 1 END

CASE WHEN TO_CHAR({datecreated}, ‘HH24′) = ’02’ THEN 1 END

……..

CASE WHEN TO_CHAR({datecreated}, ‘HH24′) = ’24’ THEN 1 END

and set the Summary Type of each result row to Sum.

Beginner Answered on June 23, 2020.
Add Comment

Probably need to extract the hour from “Date Created” with a TO_CHAR, then do some grouping.

Intermediate Answered on June 22, 2020.
Add Comment

Hi, Thanks, I did attempt this but do not seem to be having much luck with it. It seems to show up blank.

Rookie Answered on June 22, 2020.

Although i suspect this will go better in slack, share what you tried and failed

on June 22, 2020.
Add Comment

Hi, thanks managed to get it working using the above. Thanks

Rookie Answered on June 24, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor