I want guidance on using the Count and CountDistinct
Posted: Wed Jan 24, 2024 2:24 pm
I want guidance on using the Count and CountDistinct functions to filter and count a specific record in a column. For example: {CountDistinct(MV.TP_OCUPACAO, "V")}. I would like to count how many "V" records there are in the "MV.TP_OCUPACAO" column.