Not sure what is the issue here, but you are missing aggregations definitely and I can also see the timeseries are sparse and you want to have a single value anyway.
As someone who is only getting to know the metrics expressions I find it the easiest to add 2 metrics to the data explorer, presented the way I want them to be and then just create the 3 by using the metric operation.