2 Replies Latest reply: Oct 14, 2016 1:07 PM by Sunny Talwar RSS

    Bar Charts and Set expressions

    John Schown

      All,

       

      I think I am likely missing something simple here, but I a stumped.  I am working with some product usage data that looks basically like:

      MonthAccountIDUsage
      1/1/201512350
      1/1/201545675
      2/1/201512360
      2/1/2015456100
      etc

       

       

      What I want to do is create a bar chart that shows the Growth in usage each month using 1/1/2015 as the baseline.  So essentially 1/1/2015 would have a value of 0 and 2/1/2015 would have a value of 35(60-50 and 100-75)

       

      I thought I could use something like:

      Dimension - Month.autocalendar.YearMonth

      Measure - Sum(Usage) - Sum ({$<Month = {'1/1/2015'}>}Usage)

       

      But this just takes the January 2015 value to 0 and does not change any of the other months.

       

      Any suggestions?