Sparkline dimension question

[#1]

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!

[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

[#3]

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.