Finding Average based on last 5 days transaction?

ubp1252 — Sun, 04 Apr 2021 04:45:29 GMT

Hi,

We have data which will display total tarnsactions and success transactions count based on our time range.But we got one requirement that when some incident happen that time the count we are getting very less compared to other days.So our target is whenever we got that type less transactions we need to average for last 3 days total transactions and display that number instead of less transaction count.Please help how to solve this.

Sample Data:

Date	Total_tranasactions	Success_tranasactions
01-04-2021	80	70
02-04-2021	75	70
03-04-2021	100	90
04-04-2021	10	2

Expected Output:

Date	Total_tranasactions	Success_tranasactions
01-04-2021	80	70
02-04-2021	75	70
03-04-2021	100	90
04-04-2021	avg of last 3 days	2

Re: Finding Average based on last 5 days transaction?

ITWhisperer — Sun, 04 Apr 2021 06:36:21 GMT

| streamstats window=3 sum(Total_tranasactions) as rolling3total count as days by Date | eval average3days=rolling3total / days | eval Total_tranasactions=if(Total_tranasactions < 20, average3days, Total_tranasactions)

topic Re: Finding Average based on last 5 days transaction? in Dashboards & Visualizations

Finding Average based on last 5 days transaction?

Re: Finding Average based on last 5 days transaction?