Forum Discussion
Count not calculating correctly
I am trying to count text in a column but I'm getting incorrect values. Example: I have two columns Visit Date Attendance Promoter-Detractor 7/9/2023 0:00 Promoter 7/9/2023 0:00 Pr...
Yes, if you're simply looking for a count of rows where the "Promoter-Detractor" has a value of "Promoter" only, use the forumla shared and it will work just fine. You want to filter off of that column, not the date column.
So there are other dates. So I would be counting the number of "Promoters" by date in the column Promotor-Detractor.
It would be the same measure/formula. You would just use your date field in your visual or table as a column or x-axis. For this example, I used the same data you shared but changed a couple of the dates so that you can see the break of the count measure among dates.
Notice I used the same measure I shared, but now I pulled in the date column. This counts the number of "Promoter"s by date.