I am sure I am missing something really obvious here but I am trying to create a widget that shows cumulative Ticket Count on the Y-axis and Order Weeks Prior to Performance on the X-Axis but that actually shows the date rather than the week number.
Has anyone got any suggestions?
Thanks
Kerry
Hi Kerry,
[Order Weeks Prior to Performance] is just a relative count of weeks between an order date and the date of a performance associated with a ticket in that order. This helps when trying to look at sales across many performances and seasons that have many different explicit dates associated with their orders and performances. It sounds like you might want to use the [Date] field as [Weeks in Date] or [Days in Date] from the [ORDER DATE] dimension on your X-Axis, instead of [Order Weeks Prior to Performance].
With it set to display Days, it will show all distinct dates. Set to Weeks, it will show the week number and year. When grouped by Weeks, displaying the starting date of the week instead of the week number is not currently supported.