Use case
Return the number of child issues in statuses with the status category "To Do" or "In Progress".
Expression
Create and configure a Smart field using this expression in General parsing mode:
%{count(issuesFromJQL("statusCategory in ('To Do','In Progress') and parent = " + %{issue.key}))}