I am trying to calculate the Occurrences of a text field (my desired text) , but I am struggling to do it.
Lets, a column contain different fruits, and I want to count that how many times apple came in that column.
Your help will be greatly appreciated.
If you have a piece of test somewhere in your app, use Magic Text to to select Fruits > Count, then click on the pencil icon of the red Count bubble and add a filter that says where the Name of the fruit is equal to Apple.
That was Awesome! Really appreciated!