How do I get a count of values via lookup in an integer form instead of a list of numbers?

Sewon
Sewon
  • Updated

Issue

When I try to configure my lookup column's attribute as "Count field values", I get a list of numbers that looks like e.g. '0, 0, 0, 0' instead of an actual count as an integer type (e.g. 4).

 

Environment

Notebook, Lookup columns

 

Cause

The lookup column is designed to return the individual values for each instance of the entity, rather than a single aggregated count

 

Resolution steps

Add another custom column of type "Integer" and use the table function '=count(cell)'. This column will generate an integer count of the list of numbers from the lookup column.

Screenshot 2024-10-10 at 4.06.32 PM.png

Was this article helpful?

Have more questions? Submit a request