Data Driven Dynamic Static Max value in Charts

    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