Hi all,
I'm working on a pie chart that shows all the sales from the previous day, so I can get a better sense of what people are buying each day. The problem I'm running into is that it is only looking at orders created the previous day (which is initially what I thought I wanted), but if an order was created earlier and was paid yesterday (ie. Group sales) it is not being counted so my chart is not matching another report that I have running daily which does count those group sales. Thoughts?
Below is an example of the chart. I have a seperate one for Ticket Counts and Revenue.
Hi Hilary,
If you use the Finance cube instead of Seats and Tickets you can use the "transaction date" to filter to all payments from the previous day rather than orders with an order date of the previous day. You can definitely use that for the revenue chart. Unfortunately, I don't think that Ticket Counts are available in Finance so not sure about that one!
(Also just to make sure that you know how to add a widget from a separate cube into a Seats and Tickets dashboard - you just need to change the data source on the top right corner when you add a new widget).
Hope that's helpful!Sarah Covie
PortTIX
That definitely helped with my revenue widget, thank you!
Glad to hear it!