I have some issues that a chart shows me a unexpected result of a sum(x)/sum(y).
Can a bloody rooky ask a to easy question?
I load two tables:
as function to get a gauge chart
Can you pls help me?
Try with distinct keyword for first table like:
for Region selection it works. However this is a solution which would not always work, hence not recommended too.
Can you try to Load the 1st table in full but the 2nd table without the Region?
The Region-Country relationship is already defined in the 1st table, and you do not need to load that in the 2nd again.