There are certain use cases where you may not want the Y-axis max value to dynamically change as selections are made. The attached document is my solution to the question "How do I set a Static Max value in a chart that doesn't require me to update the value as the underlying data grows in the application over time?".
I hope others may find this useful!
The attached document discusses the following functions:
Ceil()
Max()
Aggr()
Enjoy!
Mark Miller
