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

주제

분석

태그

아마존 QuickSight

언어

English

rePost-User-4022341

질문됨 일 년 전469회 조회

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

답변함 일 년 전

QuickSight - Can I use countif + contains?

관련 콘텐츠