1 Reply Latest reply: Feb 3, 2013 11:29 PM by matthew thompson RSS

    Help with a Line Chart

      Hey guys, it's my first post.

       

      I need help with a line chart that I am doing.

       

      I have the Dimension set to Fiscal Year - going from 2008, 2009, 2010, 20011, and 2012.

       

      The expression is where I am having trouble.

      My Data looks like this:

      Supplier #VRR 12M FY10VRR 12M FY11VRR 12M FY09VRR 12M FY12VRR 12M FY08
      GS089298.3843400798.0540342795.88192.0146837199.51119119
      GS070199.6275978897.6700726998.0540342796.8259136195.881
      GS074996.4743559599.6059377599.6275978895.673958696.48787213
      GS065292.0146837199.079068669.004778296.4878721399.81146014
      GS017999.6059377595.673958699.9919799898.2915978482.59682982
      GS152496.8259136195.060500299.8114601482.5968298299.60593775

       

      VRR is a % (out of 100) rating a Vender's (Supplier) Reliabilty.

       

      Fiscal Year is a field in another chart

      Supplier# is a keyfield throughout all of my data.

       

      What I need to do is to make a Line Chart that plots the VRR from FY08 - FY12 But I do not know how to set up the Expression, Any help out there?

       

      Do I need to set up a new field or a variable that tells the Line Chart from which VRR box to draw data from?