Time Line with Volume

JBerr

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

JBerr

Hi Mark,

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

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