字符串和数字不匹配的聚合
字符串和数字不匹配的聚合
提问于 2021-10-08 16:45:38
我有一张桌子：
Genres Episodes
Drama 2
Drama 1
Drama 0
Comedy 2
Comedy 1
Comedy 0
Kids 3
Kids 2
Kids 1
Kids 0我想创建一个计算字段：
Genres Episodes Criteria
Drama 2 Complete
Drama 1 Partial
Drama 0 Obsolete
Comedy 2 Complete
Comedy 1 Partial
Comedy 0 Obsolete
Kids 3 Complete
Kids 2 Partial
Kids 1 Partial
Kids 0 Obsolete我的计算字段公式抛出一个错误：
ifelse({Genres} = 'Drama' and (count({Episodes}) = 2), 'Complete',
{Genres} = 'Drama' and (count({Episodes}) = 0), 'Obsolete',
{Genres} = 'Drama' and (count({Episodes}) = 1), 'Partial',
{Genres} = 'Comedy' and (count({Episodes}) = 2), 'Complete',
{Genres} = 'Comedy' and (count({Episodes}) = 0), 'Obsolete',
{Genres} = 'Comedy' and (count({Episodes}) = 1), 'Partial',
{Genres} = 'Kids' and (count({Episodes}) = 3), 'Complete',
{Genres} = 'Kids' and (count({Episodes}) = 0), 'Obsolete','Partial')错误：
Mismatched Aggregation. Custom Aggregations cannot contain both aggregate Count and non-Aggregated fields.谁能帮帮我！
回答 1
Stack Overflow用户
回答已采纳
发布于 2021-10-14 16:59:35
如果有人遇到这个不匹配聚合的问题，我找到了一个解决方法。
只需将字符串转换为数字格式(公式)，就像我做的那样：
genres_numbers:
ifelse({Genres} = 'Drama',1, {Genres} = 'Comedy',2, 3)其次，为事件列创建一个count公式：
count_episodes:
count({Episodes})然后，取两者的平均值，并将标准值指定为：
ifelse(avg({genres_numbers}) = 1 and avg({count_episodes}) = 2, 'Complete'...)这对我很有效:)
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/69499233
复制相关文章
相似问题
腾讯云开发者
