I've downloaded the free version of SAC to learn the tool, but it seems that the average function is not working on the trial version?
For example - here is the underlying data from an excel spreadsheet (One dimension and two measures):
Here is the measure calculation for the bars where I select average:
And the chart simply sums the data instead of averaging it (in fact none of the operators seem to work and data is only summed irrespective of the operator that I select).
Here is the resultant chart:
And what I want go visualize is this (a simple average by dimension):
Add comment