8 Replies Latest reply: Aug 7, 2018 8:53 AM by Jon Erik Lindberg RSS

    Combining measurements

    Jon Erik Lindberg

      I have two kinds of measurements. One measurement is used for static information. This measure shows last observed year if the user does not select year - typically in a kpi (see measurement 1). The other measurement is used to show information through years - typically in a line chart (see measurement 2). The measurements are like this:

       

      1)

      if(GetSelectedCount(Year)=0,

      Sum({<Year={$(=MAX({$<Sales -= {'=(NULL())'} >}Year))}>}Sales),

      Sum(Sales))

       

      2)

      Sum(Sales)

       

      As they are constructed I cannot use measurement 1 in a line graph for example. I would like to combine measurement 1 and 2 into a single measurement so that they will display information regardless of chart type. The main reason - it will not be easy to maintain when I have several 'dualistic' measurements of the same kind.