Hi, I'd like to count if a field (string) has a certain text included. Already tried: * countIf({ID}, {Ticket type} contains 'Wochenend') * distinct_countIf({ID}, {Ticket type} like '%Wochenend%') * distinct_countif({ID}, locate(toLower({Ticket type}), 'Wochenend') <> 0) ...but nothing worked. Would appreciate help from the community! Many thanks, Axel

QuickSight - Can I use countif + contains?

Hi, I'd like to count if a field (string) has a certain text included.

Already tried:

countIf({ID}, {Ticket type} contains 'Wochenend')
distinct_countIf({ID}, {Ticket type} like '%Wochenend%')
distinct_countif({ID}, locate(toLower({Ticket type}), 'Wochenend') <> 0) ...but nothing worked.

Would appreciate help from the community!

Many thanks, Axel

主题

分析

标签

Amazon QuickSight

语言

English

rePost-User-4022341

已提问 1 年前468 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

已接受的回答

The third option is almost correct but you have used toLower function and yet checked for 'Wochend' with 'W'(caps) instead of 'w' . Here is an example :countIf(ID,locate({Ticket type},'Wochenend')<>0)

prabaharAWS

已回答 1 年前

QuickSight - Can I use countif + contains?

相关内容