9 Replies Latest reply: Jun 26, 2017 8:30 PM by Dan Stanley RSS

    Set Analysis!  What the heck am I doing wrong?

    Dan Stanley

      I'm at my wits end in trying to get this to work.  My goal is to create a line chart (eventually a control chart) that is influenced by interventions that occur at various points along the dimension (Year Month).   I have created a dedicated table for the control chart that is not joined to any other table in the script.  I want to use set analysis to control what is seen, but I can't even get it to work for a simple numeric variable, let alone the date range I wish to apply.


      The chart currently is showing the "Median" and I would like the following to be represented in the set analysis:


      MeasureInterventionMeasureID = vMeasureID

      MeasureInterventionYearMonth between vMeasureInterventionStartYearMonth and vMeasureInterventionEndYearMonth


      The current expression in the chart works when I hard code a number for the measure ID, but my attempts at replacing it with the variable have failed.


      I am attaching the app.  Thanks ahead of time for any assistance.  It is greatly appreciated!