使用变量筛选器发现异常

[elleryliang]

我的SQL代码是： SELECT
group,
str_to_date(
concat(yearweek(Date), ' Sunday'),
'%X%V %W'
) AS date,
sum(quantity) quantity,
sum(sale_amount) sale_amount,
sum(units) units,
sum(spend) spend,
sum(sales) sales
FROM
ads_temp
WHERE group= {{group}}
GROUP BY
group,
str_to_date(
concat(
yearweek(ads_temp.Date),
' Sunday'
),
'%X%V %W'
)
当我在进行筛选时，选择1-开头的小组可以正常显示
如下：

但是当选择2-开头，或者3-开头的小组则不会显示数据

希望可以知道为什么这段SQL代码会漏掉2-后面的小组，我在Navcat for MySQL上所有的组别都是有的

[flamber]

Hi @elleryliang
If you are using a Field Filter, then you should not include column or operator.
WHERE `group` = {{group}} should just be WHERE {{group}}
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html