2 Replies Latest reply: Apr 10, 2012 3:16 PM by Shannon Lepore RSS

    Sparkline dimension question

      Hi,

       

      I’m attempting to create a sparkline within a straight table chart.  My dimension is KPI Name.  My expressions are Current Value, Target Value, Difference and the display options for these three expressions are set to Text.  I want to add an additional expression that will display as a mini chart – sparkline which will show the trend of balances for the past 12 months from today’s date.

       

      I was thinking that the best approach would be to create a dimension in the load script (Last12Mths) and then use that as the dimension for the mini chart.  I have a field that was created called MonthEndDate that I could probably use.

       

      Does this approach makes sense and if yes, can someone provide info on how I would create the dimension in my load script?

       

      Thanks!

        • Sparkline dimension question
          Nilesh Gangurde
          Hi slepore,
          use the script mention below for the dimension field of mini chart.
          date(monthstart(TempDate).'MMM-YYYY' ) as MonthYear
          Regards,
          Nilesh Gangurde
            • Sparkline dimension question

              Hi,

               

              This isn’t really getting me what I need.  I am trying to create a dimension to be used in my mini chart that will be a rolling 12 months from today’s date.  For example, I am looking to trend using a sparkline the values for April 2011 – to April 2012.

               

              If this isn’t possible to do in the load script, is it possible to create a calculated dimension for a mini chart?  It doesn’t appear to be possible which is why I was interested in trying to create this dimension in the load script.