Time Line with Volume

JBerr · 2024-02-09T17:08:53+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

JBerr

Hi Mark,

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

All comments

MarkSnodgrass

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)

JBerr

Hi Mark,

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

JBerr

Mark,

I removed a filter that I had and it worked!

Thank you

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of