Tickets sold column chart by date (broken out by hour)

Hello!

I have been trying to get a simple dashboard going that shows a column for each date with total ticket count.  But I would like to break up the single column by colors depending on the order hour.  I've trimmed it down to a 3 hour window to make things a little easier to work with but I can't get it to split out correctly. 

If I try to break by order hour, I get 3 different columns per date

I have played around with formulas and bucketing but can't seem to get it to line up in a single column.  I feel like I'm missing something pretty easy so hopefully someone in the Analytics community can help me out?

Many thanks!

-Grant

Parents Reply Children
No Data