2 Replies Latest reply: Mar 31, 2010 4:24 PM by Ludwig123 RSS

    Calculated Dimension

      Hello Guys,

      I am in the process of creating a calculated dimension and stuck with the expression to create the calculated dimension.

      I have a variable called 'SelectedDate' and that contains the date a user selects out of a slider/calendar object.

      I like the X-scale which is the dimension to display only 30 days back from the selected date. So for instance the user selects March 30, 2010 the chart build upon that dimension shows basically the month of March. If the 15th of March is slelected than it goes from 15th of Feb to 15th of March etc.

      Is there a QV function to define a dynamic daterange like this?

      How does this expression look like? Examples?

      Thanks a lot

      Ludwig