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

How do I do X?
1

Hello,

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?

2

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.