Filter not working for Cake Chart

Get Help
#1

Hey community,

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

image
image.png1877×772 58.6 KB

This is what i get.
image
image.png1900×778 42.2 KB

Can someone help me out?

#2

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

#3

Thank you for your reply!

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

#4

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

#5

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.