I think the problem is that you will need to use Aggr() function with the chart dimension to reach the output... but because your dimension is a calculated dimension... you cannot use it within Aggr() function
I actually wanted to get 6 since I am looking for the max of the average per day but I did sucess on my own.
Nevertheless I still have a little issue.
The variable indeed contains the max so 6. and the min is 1, but in the "table 1" the max and the min are changing depending on the days. I want them to be fix. In order to make my "indice" between 0 and 1