No average aggregation

Hello everyone,

I'm new in Metabase and I'm facing an issue.

Do you have any idea why I can't make an average aggregation in this case ?

But if I turn this into a model, now I can add an average aggregation on the amount.

Thanks for your answers :slight_smile:

Hi @ladislas14
I'm guessing that you are seeing this issue:
https://github.com/metabase/metabase/issues/12248 - upvote by clicking :+1: on the first post

1 Like

Hi @flamber,

Thank you very much for your answer! It seems indeed that it is the same problem.

If it can help anyone, as I use in my cas a LEFT JOIN, I got around it by reversing the order of my two tables and using a right join instead.

@ladislas14 Yeah, that's a solution for some, but it depends on your data.