2 Replies Latest reply: Nov 14, 2014 6:44 AM by Aaron Morgan RSS

    Bar not central over calculated dimension?

    Aaron Morgan

      Hi all,


      Having issues with a bar chart that uses a class statement as a calculated dimension. The dimension is calculating the sum of rainfall in a given week, and then a class statement bands this into bin widths of 5:


      Class(Aggr(Sum(Rainfall), TheWeek), 5, 'Rain')

      This is the second dimension on the chart, the first being TheWeek. There's only one expression, which calculates a sum of items sold (simply Sum(Items)).


      The graph calculates correctly, but the bar for each week isn't centralised, so it's making it more difficult to read - see the image attached!


      Any help on how to solve this? I do have TheDate as another field (which obviously links to each week) but if I'm not using it in the chart and aggregating to week level, should this cause any issues?