Time Line with Volume

JBerr
JBerr Member
in Charting

I have a request on how to create a time Monthly Stacked bar chart of Total Retail Volume with Total Member Volume and represent it by hour for any given month. I am have issues with grouping the times between 7am to 8pm; I just get every data point for the given month I don't know how to group together. Here is a picture of what I want it to look like compared to what I am getting

what I have.PNG
timeline.PNG

Best Answer

  • JBerr
    JBerr Member
    Answer ✓

    Hi Mark,

    I did put the hour beast mode in the x-axis and have the same results

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    You can use the HOUR function in a beast mode to extract the hour of the day out of your datetime field. You would then put this beast mode in your x-axis. Beast mode would look like this:

    HOUR(startdate)

    **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.
  • JBerr
    JBerr Member
    Answer ✓

    Hi Mark,

    I did put the hour beast mode in the x-axis and have the same results

  • JBerr
    JBerr Member

    Mark,

    I removed a filter that I had and it worked!

    Thank you

Categories