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?

相關內容