Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks!
You're using two dimensions in the bar chart. There will be space reserved for each bar of the second dimension and the bars will be same position for each value of the first dimension.
You're using two dimensions in the bar chart. There will be space reserved for each bar of the second dimension and the bars will be same position for each value of the first dimension.
Ah, stupid of me. I'll use a banded colour expression in the expression properties instead.
Thanks.