Skip to content

    • Magic ETL

    Magic ETL

    Charting by AM vs PM

    Member
    in Magic ETL

     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

    • 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

    • 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!

    • Member

      Genius!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories