You can use a count metric, with a split rows by name field.
Then create 2 scripted fields:
"go_count" with the value of 1 if action is go and 0 if it's stop.
"stop_count" with the value of 0 if the action is go and 1 if it's stop.
Then, in the original data table change the count metric to a sum metric of the "go_count" field.
Then add another sum metric on the "stop_count" metric.
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.