4 Replies Latest reply: Aug 3, 2018 7:16 AM by marwa zerzeri RSS

    two reference lines in a line chart

    marwa zerzeri

      Hello,

       

      I made a line chart that contains two dimensions ([Month Year] and [DATE]) and a single measure (Outstanding savings). The [DATE] is an alternative dimension. I want to display for each dimension selected in the graph the appropriate reference line.

       

      In the expression of the reference line, I did as follows but it always shows me the same reference line (the conition in the if always returns  False):

       

      = if ([Month Year] = [Month Year],

       

      avg (aggr (Sum ({$ <[Line Type] = {"Savings Outstanding"}, [Flag End Month] = {"1"}>} Balance), [Month Year])),

       

      avg (aggr (Sum ({$ <[Line Type] = {"Savings Outstanding"}>} Balance), [DATE]))

       

      )

       

      I need to know the good condition. Thanks for your help.