I want guidance on using the Count and CountDistinct
-
- Posts: 53
- Joined: Mon May 30, 2022 7:35 pm
I want guidance on using the Count and CountDistinct
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.
- Attachments
-
- Screenshot_704.png (59.93 KiB) Viewed 1346 times
-
- Posts: 6366
- Joined: Tue Mar 20, 2018 5:34 am
Re: I want guidance on using the Count and CountDistinct
Hello,
In this case, you should use the following expression:
{CountDistinctIf(DataBand,DataSource.Column, condition)}
Thank you.
In this case, you should use the following expression:
{CountDistinctIf(DataBand,DataSource.Column, condition)}
Thank you.