Allow Multiple Conditions for Calculated Properties of Type Count / Sum
It is great that we can count or sum over objects using calculated properties. However, we often have cases where we want to put not just one but multiple conditions. So if we could have filter functionality similar to the normal list filters or workflow filters where we can combine multiple conditions with AND / OR that would make calculated fields much more powerful for us.
I'm a HubSpot reporting PM and noticed this was a highly requested feature set for calculated properties. It seems like the goal of this thread is to apply one or more conditions to a a set of data and then create either a sum or a count based on the conditional filters. This can be achieved through datasets + reporting today -- pictures attached. I'm curious if the pictured reporting solution solves the user problem in this thread or is there a next step that requires this information to be saved in a property instead of a report? If yes, I would love to hear what that next operational step is and how you're using this aggregated data next, because our team is actively thinking thinking about this connection point.
Conditional Logic using if() function in datasetsReporting enabling the ability to create a summation or a count