Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ziabobaz
Creator III
Creator III

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

Hi

I use two dimensions on my chart:

1. "Week of the Year"

2. Year

The result is as follows:

Screenshot_29.jpg

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?

1 Solution

Accepted Solutions
Anonymous
Not applicable

You need max of weekly sales, so probably this

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

View solution in original post

2 Replies
Anonymous
Not applicable

You need max of weekly sales, so probably this

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

ziabobaz
Creator III
Creator III
Author

Works fine.

I now understand the logic, thank you.