CRM

TWallen
Contributor

Reports - Sorting by Number of Sales Activities and (No Values)

I'm creating a Deals report with the intent to sort deals in the table by the number of sales activities. The sort order should be descending so the deals with the most activities are at the top of the table. 

 

The issue is HubSpot puts the deals with (No Value) above the deals with the most activities. Seems it would be common sense for (No Value) to be quantified as 0 so those appear at the bottom of the list in this sort order.

 

TWallen_0-1682469272296.png

 

2 Replies 2
Darrin_Caldwell
Participant

Reports - Sorting by Number of Sales Activities and (No Values)

This issue impacts the Average Number of Sales Activities. It doesn't identify "--" as zero, so the averages are not accurate. 😕 

0 Upvotes
TWallen
Contributor

Reports - Sorting by Number of Sales Activities and (No Values)

Response from Sara on 4/25/2023.

TWallen_0-1682470412379.png

 

0 Upvotes