I'm trying to run mstats query for metric index to filter based on the metrics value. i.e, _value. I'm aware that splunk not allow directly using the _value field to filter either by where or group by options. Just want to understand is there any other way we can filter based on the _value.
One work around I have in mind to use the same metric value field as one of the dimension and use it on the filter. Any other option without using this work around will be more helpful.