Can someone help me with a beast mode to fix this? I would like it to start at 12a and to end at 11p

rbastien
rbastien
in Charting
image.png


Answers

  • GrantSmith
    GrantSmith Coach

    What is your beast mode and are you sorting by any values?

    You may need to create a new beast mode for HOUR(`Timestamp`) and sort on that so it's sorting based on a 0-23 value instead of doing string sorting.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MarkSnodgrass
    MarkSnodgrass Coach

    If this is displayed in a table, you can create a beast mode to deal with the sorting. You can use the HOUR() function to extract the hour (0-23) from the datetime field and then drag that into your sorting property and sort by ascending. You could also use the UNIX_TIMESTAMP() function and drag that into the sorting.

    If this is for a quick filter, then you are in a more difficult position as that thinks everything is a string for this.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • GrantSmith
    GrantSmith Coach

    @MarkSnodgrass - I win 😋

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • MarkSnodgrass
    MarkSnodgrass Coach

    @GrantSmith by a millisecond .... again. :)

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • rbastien
    rbastien

    Thank you guys.

Categories