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
.