topic Re: Count based on a rolling average in All Apps and Add-ons

Count based on a rolling average

akpadhi — Wed, 10 Mar 2021 06:11:03 GMT

I have following query which provides me details of a db userid whenever the count crosses X value, however I want to modify this to a dynamic search based on a rolling average of that value for last 10 days. Can you pls help?

I want to modify the where condition to where connection_count > 'avg (conn count for last 10 days)'.

Re: Count based on a rolling average

ITWhisperer — Wed, 10 Mar 2021 09:13:20 GMT

I presume you want time to be part of your stats and that the ten day average is for application_user and pdb.

Re: Count based on a rolling average

akpadhi — Wed, 10 Mar 2021 11:09:49 GMT

@ITWhisperer i am getting an error Error in 'streamstats' command: time_window can only be used on input that is sorted in time order (both ascending and descending order are ok).

tried few options nothing worked, can you pls cross check..

Re: Count based on a rolling average

ITWhisperer — Wed, 10 Mar 2021 11:18:27 GMT

| stats ... by _time ...

should be sorting by _time for you