Dashboard based on subset of span durations within the same trace

I have a following situation:

My system generates traces that are divided into separable spans. It is not possible to create one parent-span due to the fact that each operation is performed on a separate machine / on a different service.

I would like to create a panel on the dashboard that would calculate the average execution time of spans “one”, “two”, “three” for all traces named “Sample” and for env.name = ‘dev’.

If we take the case from the image, the panel should display the value “6 seconds” (start of span “three” plus duration of span “three” minus start of span “one”).

Is it even possible to create such a dashboard in Grafana based on Tempo datasource at this time? I’ve tried to do it using various transformations, but so far I haven’t succeeded.