topic Re: Test search with stats function "|inputlookup app_usage.csv | stats perc(Webmail, 10.0)" in Splunk Data Stream Processor

Test search with stats function "|inputlookup app_usage.csv | stats perc(Webmail, 10.0)"

athlonshi — Fri, 20 Aug 2021 14:43:23 GMT

New to Splunk and experimenting a couple of functionalities, especially data aggregation

With the experimental file app_usage.csv, I was trying to see the percentile of Webmail using

|inputlookup app_usage.csv | stats perc(Webmail, 10.0)

but it returns error

Percentile must be a floating point number that is >= 0 and < 100.

Not sure what to do, tried to cast Webmail to float also failed

|inputlookup app_usage.csv | eval Webmail=cast(Webmail, 'float')

with error

Error in 'eval' command: The 'cast' function is unsupported or undefined.

cast should be in the eval command, right? Based on the documentation.

Re: Test search with stats function "|inputlookup app_usage.csv | stats perc(Webmail, 10.0)"

ITWhisperer — Fri, 20 Aug 2021 15:34:44 GMT

I am not sure what the data that you are using is or what you are trying to get out of it but try

|inputlookup app_usage.csv | stats perc10(Webmail)

Re: Test search with stats function "|inputlookup app_usage.csv | stats perc(Webmail, 10.0)"

athlonshi — Fri, 20 Aug 2021 15:37:39 GMT

Just using the sample data to MLT and experimenting with it. Interesting that Splunk doc has perc as a stats function but it did not work. Yes, your way works. Thanks!