Data blend / Country filter

Hi. I want to make a looker report with the metrics listed below. Since the metrics are in different reports in Matomo I have used datablend.

But when I try to put in a filter/control field using the country dimension the data is all messed up.

I need to put in this filter/control to that I can see the total data + for performance for each market (US, DE, UK etc.) when using the filter.

These are the metrics that I need - therefore I have made a datablend across for the different reports/data sources.

  • Sessions
  • Bouncerate
  • Pages per session
  • Avg time on site
  • Ecom number of ordrers
  • Ecom rate
  • Ecom revenue.
  • Ecom revenue per order.

Any thoughts on how to solve this?