I am trying to create a countif calculated field that counts the number of times a certain error is returned over the last 2 years. The exact error showing in the data set is
“At the instruction of this consumer, a security freeze is in effect with respect to the consumer’s credit file. No information in the consumer’s credit file may be released to a third party without prior written authorization from the consumer.”
Quicksight says the below formula has errors and I am assuming it has to do with the apostrophes within the field and was wondering if there is a wildcard or any other way I can use to tell quicksight to disregard the apostrophe in the field or to look for just the beginning of the error before the apostrophe in “consumer’s”?
(
countIf({clarity_status_descriptions},
{clarity_status_descriptions} = ‘“At the instruction of this consumer, a security freeze is in effect with respect to the consumer’s credit
file. No information in the consumer’s credit file may be released to a third party without prior written authorization from the consumer.”’))
/count({completed_at}
)
Thanks!