2 Replies Latest reply on Aug 5, 2013 4:58 AM by Shawn Wallwork

    Alternative for 'Ago' function in Tableau

    vibha.gojanur

      Hi,

       

      I'm trying to replicate few OBIEE reports in Tableau.Stuck up with a calculation.Scenario is something like this, I want to take Current Quarter-4 i.e.,I want previous 4 quarters from current Quarter.This Quarter is a dynamic value.Calculation is like this- (sum(ifnull(Fact_Bookings_Agg_Product.DETAILTOTAL , 0)) / nullif( Ago(sum(ifnull(Fact_Bookings_Agg_Product.DETAILTOTAL , 0)), [Level Quarter], 4) , 0) - 1) * 100 .What is the alternative for "Ago" function in Tableau?

       

      --

      Regards,

      Vibha