HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Counting Public Updates for outgoing and incoming


#1

We need to a filter that counts the number of public updates for a specific category of user. These updates need to be then further filtered (and counted)into outgoing and incoming for each day, week and month. Is there a way to set this up for an auto-generated listing.


#2

Hi Jennifer,

You can use the filter condition public update count, but there’s no count currently which would give you a comparison of incoming vs outgoing, just a total.

You could maybe do something custom with the SQL Where clause condition and the database using a subquery but it would be a little tricky and fairly database intensive (especially on MySQL which is bad subquery support).