Data Driven Dynamic Static Max value in Charts

[m2r4miller]

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

[#2]

Is it possible to do this with variables used as the expression?

[m2r4miller]

Sorry for the delay, but I would think you could use variables in the expression.