I am struggling on a chart and cannot understand where I am going wrong, if it is data setup or graph setup. I have a data set as defined below:
2015 Qtr 2
2015 Qtr 3
2015 Qtr 4
2016 Qtr 1
when I set a bar chart I want to have the sum of the Instances (ie 10) however when I set the properties and the expression for the data is Sum(Instances) for some reason I get 10 but I have 5 bars instead of 1. Any ideas as to why?
Please share screenshot of the bar chart to help us figure this better. First question here is to understand what dimension (X axis) do you have in that bar chart? Initial guess here is that perhaps the bar chart is ignoring dimension and is summing up all (hoping there is no set analysis expression to ignore dimension)
Thank you all for the comments and apologies for the late reply. Unfortunately got side tracked. I ended up finding my error and basically it was where I had the expression to sum the numbers. I have now fixed the issues.