计算字段报Mismatched Aggregation错误 如何生成Criteria分类字段

你编写的公式中错误对Episodes字段使用了count()聚合函数：你的需求是逐行判断当前行Episodes字段本身的数值，不需要统计该字段的计数，聚合函数和非聚合的Genres字段混合使用就会触发聚合不匹配报错，直接去掉所有count()包裹即可解决问题。

ifelse(
{Genres} = 'Drama' and {Episodes} = 2, 'Complete',
{Genres} = 'Drama' and {Episodes} = 0, 'Obsolete',
{Genres} = 'Drama' and {Episodes} = 1, 'Partial',
{Genres} = 'Comedy' and {Episodes} = 2, 'Complete',
{Genres} = 'Comedy' and {Episodes} = 0, 'Obsolete',
{Genres} = 'Comedy' and {Episodes} = 1, 'Partial',
{Genres} = 'Kids' and {Episodes} = 3, 'Complete',
{Genres} = 'Kids' and {Episodes} = 0, 'Obsolete',
'Partial'
)

ifelse(
{Episodes} = 0, 'Obsolete',
{Genres} IN ('Drama', 'Comedy'), ifelse({Episodes} = 2, 'Complete', 'Partial'),
{Genres} = 'Kids', ifelse({Episodes} = 3, 'Complete', 'Partial'),
'Unknown'
)

内容的提问来源于stack exchange，提问作者Jake Wagner