Hi Liviu, using Aggr() only by customerid in a chart whit a dimension like date can lead to this kind of issues, try adding your chart dimension to the Aggr() funtion:
sum(aggr(if(sum(Value 1)>sum(Value 2),sum(Value 2),sum(Value 1)),date, customer id))
Also maybe this expression gives better performance:
sum(aggr(RangeMin(sum(Value 1), sum(Value 2)),date, customer id))
thank you very much - that obviously worked flawlessly !
what I did not know was that the AGGR function accepts more than 1aggregation criteria (date AND customer, in my case)... I was trying to use 2 AGGR functions, which did not work because nested aggregations are not allowed (except when using the TOTAL qualifier, but that was not helpful in my case, because it aggregated accross all dates)
thank you once again, this is a fantastic piece of software!