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?