How to show comparison graph of jenkins pipelines steps between two builds

[khandelwaly]

Hi Team,

I want to show comparison graph of jenkins pipeline steps between two jenkins build. How can i get it?
i am able to get the table with all duration, stage name with following queries.

index="jenkins_statistics" (host=jenkins.com/test) event_tag=job_event type=completed "stages{}.name"="" "stages{}.children{}.exec_node"="" |rename stages{}.duration as stageduration | rename stages{}.name as stageName | rename "stages{}.children{}.exec_node" as pipeline_nodes| eval exec_nodes=mvdedup(pipeline_nodes)
| eval build_on_node=coalesce(exec_nodes, node) | table build_on_node, job_name, stageName, stageduration

[to4kawa]

index="jenkins_statistics" (host=jenkins.com/test) event_tag=job_event type=completed "stages{}.name"="" "stages{}.children{}.exec_node"="" 
| rename stages{}.duration as stageduration 
| rename stages{}.name as stageName 
| rename "stages{}.children{}.exec_node" as pipeline_nodes 
| eval exec_nodes=mvdedup(pipeline_nodes) 
| eval build_on_node=coalesce(exec_nodes, node) 
| table build_on_node, job_name, stageName, stageduration
| eval stage=build_on_node."_".job_name."_".stageName
| chart sum(stageduration) as stageduration by stage

| table build_on_node, job_name, stageName, stageduration
If you provide the results, we could create query.