I'm needing to create a calculated column where I get the total count for the status column where the value equals 'Completed' and then get the percentage of 'Completed' for all the records.
I have this but it doesn't appear that Looker Studio has a CountIF function:
COUNTIF(status = "Completed") / COUNT(*) * 100