5 Replies Latest reply: Oct 6, 2011 12:40 PM by Rosalie Ramos RSS

    Graph Problem

      Hello,

       

      Please help, I was wondering how to fix the graph below.

      Here's my graph last January 2011

      1.bmp

      and here's my graph for this month. The scale is too high.

      2.bmp

      Here's the expressions I used

       

      Static Max:

      =ceil(max(aggr(sum([Volumes]),[MMM-YY])),   pow(10,len(textbetween(round(max(aggr(sum([Volumes]),[MMM-YY]))),'','',1))-2))

       

      Static Step:

      =ceil(max(aggr(sum([Volumes]),[MMM-YY])),   pow(10,len(textbetween(round(max(aggr(sum([Volumes]),[MMM-YY]))),'','',1))-2))/8

       

      Thanks,

      Salie