Charting by AM vs PM

jlazerus

 I'm pulling in data from salesforce and I want to measure it by number of cases opened in the AM vs PM.  Is there a way to do this in beastmode or though an ETL?

 

Here is a sample:

153148

unassigned

Test Ticket

The status of your ticket is now Pending/Created as Pending.

9-Nov-17 1:23:00

zcameron

You could create a beast mode to use as a category or series that determines whether a time is AM or PM like this:

 

CASE
    WHEN HOUR(`Date`) < 12 THEN 'AM'
    ELSE 'PM'
END

 

Just substitute your date column into the HOUR function.

 

I hope that helps!