Aggregation over Full Set

[peter_burgess]

I have a bar chart where the Dimension is a field, denoting the number of days a particular manufacturing job is either ahead or behind its due date. So the range can go from -20 to +20. The name of the field is 'Diff'.

The Expression in the chart is a Count, being the number of Jobs that have that same amount of days' advance or delay over their due date. The expression is therefore, No of Jobs = Count(JobNumber).

The chart works fine. However, what I want to do is set the Y-axis to a fixed maximum value, that is based on the maximum Count over the Full Set of records, i.e. over {1}. So that when I make a selection , the scale of the chart does not suddenly change.

But I cannot seem to get the correct syntax in the Static Max axis expression. My latest attempt is:

         =1.1*(max({1}aggr(Count(JobNumber),Diff)))

but this still lets the chart choose its own maximum scale whenever I narrow down a selection.

My hunch is that what I should be doing is calculating the maximum scale in the script and then call that value in the axis expression, but before I approach that course of action I would like to satisfy myself that I am not making some basic flaws in my expression syntax.

Can anyone offer some advice or point me in the right direction?

Best regards,

Pete

[swuehl · Accepted solution]

You probably need to apply the set identfier 1 to both aggregations:

=1.1*(max({1} aggr(Count({1} JobNumber),Diff)))

[peter_burgess]

Thank you swuehl, that worked perfectly .

Best,

Pete