2 Replies Latest reply: Jan 2, 2013 12:24 PM by Nicole Smith RSS

    Using a Variable in an Expression in a Bar Chart

      I'm trying to limit a bar chart to use only the latest date from the underlying data. (Other charts use the data for the latest month.)

       

      The data load sets a variable called vMaxDate - right now the value of vMaxDate is 2012-12-31.

       

      If I set the Expression for the bar chart to

       

           NumericCount({$<BusinessDate={$(vMaxDate)}>} BusinessDate)

       

      I get nothing on the chart.  However, if I replace $(vMaxDate) with its value and use

       

           NumericCount({$<BusinessDate={'2012-12-31'}>} BusinessDate)

       

      I get a correct chart.