The only way I see to do this would be with a runtime field but this will be slow most likely...
The runtime field could emit 0 when not a number and the number when it can be transformed as a number.
Then you can aggregate with a sum agg on that field I think.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.