2 Replies Latest reply: Jan 10, 2017 4:40 PM by Jared Papador RSS

    Linest Year vs MonthYear

    Jared Papador

      I have a bar chart that shows units by month year.  I am trying to make a second expression that is a linear trend line.  When I use the first expression (Year) it works but displays in the fashion shown in the year attachment. 

       

      When I try to use the Month Year expression it doesn't display anything (shown in MonthYear attachment).  Any ideas?

       

      I think I am missing something simple:

       

      Year Screenshot expression

      Linest_M(TOTAL Aggr(Sum(Units), Year), Year)

      *

      Only( Year)

      +

      Linest_B(TOTAL Aggr(Sum(Units), Year), Year)

       

      MonthYear Screenshot Expression

      Linest_M(TOTAL Aggr(Sum(Units), MonthYear), MonthYear)

      *

      Only( MonthYear)

      +

      Linest_B(TOTAL Aggr(Sum(Units), MonthYear), MonthYear)