Hello Everyone,
I am trying to create a dashboard widget that will show YOY weekly revenue by order date. I can't seem to find a way to line everything up. What i would like is each week regardless of fiscal year to line up. Any help would be appreciated.
Thanks,
Hey Anthony.
2 options come to mind: a) You might look at X axis ORDER DATE > CALENDAR WEEK OF YEAR and Y axis TICKET PAID AMOUNT. The break by is the interesting thing. You could do the Campaign that the Performances are in by Break by PERFORMANCE CAMPAIGN > CAMPAIGN
b) you could bucket them by having a different filtered values ( sum([Ticket Paid Amount]) , [Campaign1] ) - right click and filter the red bit. I go into bucketing a but here if that helps https://community.tessituranetwork.com/topical_groups/analytics-coffee/f/discussions/29816/grouping-rows-of-a-pivot-table
Also, (a) using ORDER DATE > Fiscal Week of Year.