This is the table. How can I group together similar names into one entry and the count is added for both of them. For example 5-Mock Activity and 6-Mock activity should come in 1 row as "Mock Activity" and count for that field should be 19+5 i.e. 24
Just add this before stats command.
|rex field=environment "\d\s\-\s(?<environment>.*)"
yes it's working but the thing is there are many other fields which have similar names for example stage and staging, these two also need to be counted as one "Stage" how to do that?
You can replace those value by adding below search after rex command.
| replace "stag*" WITH "Stage" IN environment