31 Replies Latest reply: Jul 13, 2015 10:13 AM by Sunny Talwar RSS

    embedding a measure (constructed variable) in another measure

    Jes Lee

      Is it possible to reference a measure to construct another measure? 

       

      I created a measure to calculate the % change over time.   Then, I would like to reference this new variable to create another measure needed for the range slider - 

       

      i.e.,

      % change measure -  

      num(sum(RETAILTRADE_MSA)/below(sum(RETAILTRADE_MSA)) -1,'#.0%')

       

      new measure for range slider -  this is required for the range slider extension that I am using.   It references the min/max values of the variable.   However, I would like to reference the % change measure.  

       

      Sum({$<RETAILTRADE_MSA ={">=$(=vMin_RETAILJOB) <=$(=vMax_RETAILJOB)"}>} RETAILTRADE_MSA)

       

       

      It is not working well, but not sure if it's the extension that is not working or if it's not working because it is not possible to reference another created measure. 

       

       

      Thank you,

      Jessica