I need to calculate if more than 15% of "error1" in server logs are there since last release. Release is every Wednesday (weekly) Sat Sun Mon Tues Wed Thru Fri 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Release 1 cycle - from 6th to 12th , Release 2 cycle - 13th to 19th and so on for a month For examples: So, if splunk query runs on 14th , it should find "errors1" count in server logs from 6th to 12th as "count1". Then, it should find "errors1" count in server logs from 13th to 14th as "count2". Then calculate the percentage increase in "count2" from "count1" If splunk query runs on 20th , it should find "errors1" count in server logs from 13th to 19th as "count1". Then, it should find "errors1" count in server logs on 20th as "count2" . Then calculate the percentage increase in "count2" from "count1". If splunk query runs on 18th , it should find "errors1" count in server logs from 6th to 12th as "count1". Then, it should find "errors1" count in server logs from 13th to 18th as "count2" . Then calculate the percentage increase in "count2" from "count1". Calculate if more than 15% of "error1" in server logs are there since last release. Please help!
... View more