That was a fun one!
| makeresults
| eval raw="Project_a,Sprint_1,5
Project_a,Sprint_2,10
Project_a,Sprint_3,4
Project_a,Sprint_4,3
Project_b,Sprint_1,20
Project_b,Sprint_2,3
Project_b,Sprint_3,5
Project_b,Sprint_4,4
Project_c,Sprint_1,4
Project_c,Sprint_2,8
Project_c,Sprint_3,4
Project_c,Sprint_4,5"
| makemv delim="
" raw
| mvexpand raw
| rename raw AS _raw
| rex "^(?<Project>[^,]+),(?<Sprint>[^,]+),(?<points>.*)$"
| fields - _*
| rename COMMENT AS "Everything above should be replaced with your 'Query-1'"
| eval Sprint_and_points = Sprint . ":" . points
| stats list(Sprint_and_points) AS Sprint_and_points BY Project
| append
[| makeresults
| eval Sprint="Future_1 Future_2"
| makemv Sprint
| mvexpand Sprint
| fields - _*
| rename COMMENT AS "Everything inside of this append should be replaced with your 'Query-2'"]
| eventstats list(Sprint) AS Sprints
| where isnull(Sprint)
| eval Sprint = mvappend(Sprint_and_points, Sprints)
| fields Project Sprint
| mvexpand Sprint
| rex field=Sprint "^(?<Sprint>[^:]+):(?<points>.*)$"
... View more