Filter not working for Cake Chart

Hey community,

I am trying to get my filter working on my Cake Chart but i can't get it to work!


This is what i get.

Can someone help me out?

Hi @CalvinW
It’s not a problem with the visualization - you cannot use table aliases with Field Filters:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html

https://github.com/metabase/metabase/issues/3324 - upvote by clicking :+1: on the first post

Thank you for your reply!

Is there a good tutorial for making that kind of field filters?

@CalvinW You don’t think the article I linked to is good? What specifically are you looking for?

I didn’t understand the article.
My colleague helped me with this one and i finally got it to work.

The problem was, i forgot to add something to my SQL.