I need to display the count of a specific value in a column.
- Status column in table1 will have values like Complete, In Progress and Pending.
- I need to get the count of them to display in a text widget - sort of like a small dashboard
What should I put in the text property to get the count? Or do i have to run a query to get the count and then run it in the text?