• Replies 1 reply
  • Subscribers 961 subscribers
  • Views 112 views
  • Users 0 members are here
Related

Subs reporting - cumulative through last week, this week's sales

Kathleen Smith
$organization

Hi everyone,

I'm looking at using Analytics for some of our subs reporting and was hoping you all could point me in the right direction on something.  I'm looking to do a widget on package revenue and count, with cumulative totals to last week, and then this week's counts.  Getting packages, and their cumulative revenue/seats is easy, I'm just not sure how to subtotal everything through last week, and then also add this week's data too.  

Thanks,
Kathleen 

  • $organization

    Hi Kathleen,

    Likely you'll want to use filtered values for this using [the ORDER DATE].[Date] as the filter. For the This Week filter...

    For the Everything thru Last Week filter, duplicate the value and edit the filter changing it to Last 2 Weeks, and then click the Advanced tab, and change the 2 to something like 105 for the past 2 years, or even 1000... just something that will include as much time prior to last week as you need.