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?
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.
