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 Domo Employee
    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:

     

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

     

    Just substitute your date column into the HOUR function.

     

    I hope that helps!

Answers

  • zcameron
    zcameron Domo Employee
    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:

     

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

     

    Just substitute your date column into the HOUR function.

     

    I hope that helps!

  • Genius!