Hi,
I got a problem visualizing my results.
I use aggr twice to sum up values on 2 dimensions and then find the lowest one.
the calculation works fine but somehow the dimension is wrong.
I attached a sample:
first I group bids by lane & provider with
Aggr(sum(bid, [Item ID])
next I try to find the lowest value among the lane bids
Aggr(min(aggr(sum(bid, Item ID])), Division)
As I said the calculation works fine.
Now I do not understand how QV works here
Somehow QV connects the result of the second calculation to a dimension which is not the one related to the value.
When I try to visualize the lowest bid and related information/dimensions does not match the value.
Any ideas appreciated!