topic Getting different result when do search query and same implement on dashboard for percentage of success to total jobs in Splunk Cloud Platform

Getting different result when do search query and same implement on dashboard for percentage of success to total jobs

Impavan5 — Thu, 05 Oct 2023 17:31:24 GMT

index="jenkins_console" source="*-deploy/*" NOT (source="*/gremlin-fault-injection-deploy/*" OR source="*pipe-test*" OR source="*java-validation-*") ("Approved by" OR "*Finished:*") | fields source | stats count(eval(match(_raw, "Approved by"))) as count_approved, count(eval(match(_raw, ".*Finished:*."))) as count_finish by source | where count_approved > 0 AND count_finish > 0 | stats dc(source) as Total | appendcols [ search(index="jenkins_console" source="*-deploy/*" NOT (source="*/gremlin-fault-injection-deploy/*" OR source="*pipe-test*" OR source="*java-validation-*") ("Finished: UNSTABLE" OR "Finished: SUCCESS" OR "Approved by" OR "Automatic merge*" OR "pushed branch tip is behind its remote" OR "WARNING: E2E tests did not pass")) | fields source host | stats count(eval(match(_raw, "Approved by"))) as count_approved, count(eval(match(_raw, "Finished: SUCCESS"))) as count_success, count(eval(match(_raw, "Finished: UNSTABLE"))) as count_unstable, count(eval(match(_raw, "Automatic merge.*failed*."))) as count_merge_fail, count(eval(match(_raw, "WARNING: E2E tests did not pass"))) as count_e2e_failure, count(eval(match(_raw, "pushed branch tip"))) as count_branch_fail by source, host | where count_approved > 0 AND (count_success > 0 OR (count_unstable > 0 AND (count_merge_fail > 0 OR count_branch_fail > 0 OR count_e2e_failure > 0))) | stats dc(source) as success ] | stats avg(success) as S, avg(Total) as T | eval percentage=( S / T * 100) | fields percentage,success, Total

Re: Getting different result when do search query and same implement on dashboard for percentage of success to total job

richgalloway — Thu, 05 Oct 2023 17:32:40 GMT

Please use the body of the message to ask your question. Tell us how the search results differ when run in a dashboard.

Re: Getting different result when do search query and same implement on dashboard for percentage of success to total job

Impavan5 — Thu, 05 Oct 2023 18:21:35 GMT

when i do query for percentage of success to the total jobs it gives result 87.716 but when i see on dashboard it gives result 90

Re: Getting different result when do search query and same implement on dashboard for percentage of success to total job

Impavan5 — Thu, 05 Oct 2023 18:42:20 GMT

Can you pls assist with valid solution for above query.

Re: Getting different result when do search query and same implement on dashboard for percentage of success to total job

bowesmana — Fri, 06 Oct 2023 00:54:12 GMT

What is your time range for both searches?

Re: Getting different result when do search query and same implement on dashboard for percentage of success to total job

Impavan5 — Fri, 06 Oct 2023 05:29:05 GMT

time range :last onemonth

Re: Getting different result when do search query and same implement on dashboard for percentage of success to total job

Impavan5 — Fri, 06 Oct 2023 06:56:10 GMT

Hi ,
issue fixed , time range i was taken static instead of default. Thanks.