• Replies 10 replies
  • Subscribers 961 subscribers
  • Views 250 views
  • Users 0 members are here
Related

YOY Weekly comparison

Tony Hatch
$organization

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,

Parents
  • $organization
    So what I am looking for is comparing package sales across 5 years by week. I was asked to even out the data so that week one is when the renewal on-sale started. I though If I tied it to campaign week then It would line up on the widget. I would just adjust the start date for all package campaigns to start with the Monday of the package on sale date across the 5 years and that would line up the package sales for an easier comparison.
     
    Thank you,
    Phillip De Leon
     
    Looking forward I will be out:
    Friday, May 6th
    Tuesday May 31st
     
Reply
  • $organization
    So what I am looking for is comparing package sales across 5 years by week. I was asked to even out the data so that week one is when the renewal on-sale started. I though If I tied it to campaign week then It would line up on the widget. I would just adjust the start date for all package campaigns to start with the Monday of the package on sale date across the 5 years and that would line up the package sales for an easier comparison.
     
    Thank you,
    Phillip De Leon
     
    Looking forward I will be out:
    Friday, May 6th
    Tuesday May 31st
     
Children
  • $organization in reply to Phillip De Leon

    Makes perfect sense, Phillip.

    I'll put in an enhancement request for time between package campaign start date and order date. In the meantime...

    You could adjust all the Default Sales Dates Start Dates across all the performances in the packages to the dates in question and then after a full data load, use the Order Weeks Since Onsale field.

    You could explore a customization to Analytics for Order Weeks from Package Campaign Start Date by opening a ticket with hello@tessituranetwork.com.