0 Replies Latest reply: Jun 28, 2012 4:21 AM by Danielle Sayed RSS

    Calculated dimension or expression to select between dates

      Hello there,

       

      I currently have a calculated dimension in a bar chart which is an 'if match' statement specifying specific months that I would like to show in the chart. However I would like the chart to have more functionality so that I do not need to hard code the months that I wish to display. I would only ever like to display the months between now and 6 months in the future. I have both date and month fields in my data. Am I best to set this as a calculated dimension or use set analysis in my expression?

       

      Any advice on the best way to select between dates would be much appreciated.

       

      Thanks,

       

      Danielle