Grouping Failure in Looker Studio with Matomo Connector

[Lynn-777]

There is a critical issue with the Matomo Connector used in Looker Studio where identical values from calculated fields are not being grouped as intended across all visualizations, including pie charts, tables, and others. This bug disrupts data analysis, as each instance of a value is treated as unique, leading to a fragmented and misleading representation of the data.

Steps to Reproduce:

• Connect Looker Studio to Matomo using the Matomo Connector.
• Create a calculated field that should logically group identical values together.
• Attempt to visualize this data in a pie chart, table, or any other visual format.

Expected Behavior:
The visualization should consolidate identical values into single groups for clear and accurate data representation, irrespective of the type of visualization used.
(see Screenshot: left: Matomo Connector right: GA4 Connector)

Actual Behavior:
Despite the use of calculated fields designed to group identical values, the visualizations treat each instance as unique. This results in an inflated number of groups and an erroneous depiction of the dataset. This issue is observable in pie charts, where it generates an excessive number of slices, as well as in tables, where rows that should be combined are instead displayed separately.

Impact:
This bug severely affects the usability of Looker Studio with the Matomo Connector for meaningful data analysis and visualization, as it prevents accurate aggregation of data points.

Additional Information:

The problem persists regardless of the visualization format.
This is not an isolated issue; it has been replicated with various data dimensions.

[Lynn-777]

Even using dimension fields such as "Search Engine" without filters or calculated fields won't display correctly.

[diosmosis]

@njoyhwsm What version of Matomo are you connecting to?

[Lynn-777]

@diosmosis

We use Matomo Cloud. So I guess it is the latest version.

[diosmosis]

I see, yes, this is a known issue with the connector and Matomo at present. More details on the work needed to add this and details on a workaround are here: #3

[Lynn-777]

Thank you for these links, they have helped me understand that by re-aggregating the appropriate metric, the values will indeed be grouped as desired. :)