Charting by AM vs PM

 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:

153148unassignedTest TicketThe status of your ticket is now Pending/Created as Pending.

9-Nov-17 1:23:00

Best Answer

  • zcameron
    zcameron admin
    Answer ✓

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


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


    Just substitute your date column into the HOUR function.


    I hope that helps!