Custom range for Y-axis as maximum value of the measure + fix number

[ziabobaz]

Hi

I use two dimensions on my chart:

1. "Week of the Year"

2. Year

The result is as follows:

Now I want to create a custom range for the Y-axis, which is the maximum weekly sales out of the filtered range (in the example it is the week 16) plus fixed value.

The formula I put is:

Max([Sales])+{1.000.000}

It does not work.

Am i missing something?

[Anonymous · Accepted solution]

You need max of weekly sales, so probably this

max(aggr(sum(Sales),Week,Year)) + ....

[ziabobaz]

Works fine.

I now understand the logic, thank you.