5 Replies Latest reply on Feb 12, 2013 7:14 AM by Jeremy Riberdy

    Extract historical data dependant on current date

    Jeremy Riberdy

      I am trying to find a way to use the date range filter to extract historical data based on a current date. Example:

       

      The date filter range is from 1/1/2008 - 12/31/2012 (is visible and can be manipulated/filtered) - for this example let's use 1/1/08 as the start date and 12/1/2012 as the target end date

      Data displayed is trend line for Customer ABC's revenue over time - for this example I see that Company ABC's revenue went to $0 in December 2012

      In an effort to see how muc revenue I lost I am trying to look back to see how much revenue was generated by Company ABC 8 months before it got to $0, in an effort to guess at what the annual revenue lost might be (when they were in a "steady state").

       

      I tried to use the formula DATEADD('month', -8, [DAY]) but all that did was timeshift all my data backwards by 8 months.

       

      Is is possible to filter data using one date filter but then show these trend results by another date?