4 Replies Latest reply: Nov 12, 2015 2:43 PM by Ron Payne RSS

    Filtering a Chart by Date Selection Stored in a Variable

    Ron Payne

      Hi All,

       

       

      I have an issue getting a date variable that's being fed it's value through a calendar object to filter charts by it's value. The variables are vMinDate and vMaxDate. This is the calculated dimension i'm using to filter the chart by the vMinDate information (the chart is titled Make__c. Screen shot attached):

       

       

       

      = if(SnapshotDate = date($(vMinDate)) , SnapshotDate)

       

       

       

      As you can see in the below screenshot, this is causing a null value to be returned.

       


      Any suggestion on filtering a chart by passing the value stored in a variable into a field selection?

       

       

       

       

       

      Thanks a lot,

       

      Ron