How to count number of entries with a specific value in a table column?


I need to display the count of a specific value in a column.
E.g :

  • 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?

Hello! To count, for example, the number of rows for which the status is “In Progress”, you can use in your text widget {{Table1.tableData.filter(row => row.status == "In Progress").length}}, where Table1 is the table’s name and status is the column’s name.