1 2 Previous Next 17 Replies Latest reply on Aug 3, 2016 8:23 AM by Hildebrando Souza Jr

    KPIs and Trend Lines on the Same Worksheet

    Ashwin Chandak

      Hello,

       

      I hope this post find you all well!

       

      I have a table that has the 3 fields:Product, Value A, Value B, (Value A - Value B ) Difference%,

      I also have created 4 parameters : Range A start, Range A End, Range B start, Range B End

       

      Im trying to accomplish the view that is similar to the one in the image attached (please pardon the shadow)

       

      Value A: WIll Aggregate the values of Product in the Range A Start to Range A End

      Value B: WIll Aggregate the values of Product in the Range B Start to Range B End

      Difference: Calculate the Difference between Aggregated values of A and B

      Trend A- Will show the each data point of Value A from Range A start to range A end

      Trend B - Will show the each data point of Value B from Range B start to range B end

       

      Is there a way I could accomplish the same using a single worksheet.

       

      I have found this resource that is similar: Tableau Tip: KPIs and Sparklines in the Same Worksheet

       

      Any workarounds and help would be immensely helpful. Thank you.

       

       

      -Ashwin

        1 2 Previous Next