Report totals only computes first row number

[rcontiuk]

Customer reported the issue on several reports in Looker Studio. The total only includes the first row number, see screenshots below:

[diosmosis]

There's no way to get the report totals via the Matomo API through the connector so I'm guessing this totals row was added via Looker Studio?

In this case, this will be fixed by #3.

[goochj03]

I've had another customer affected by the summary rows not reporting correctly when using the Looker Studio connector.
Using the blend data option helps with table reports show the summary but options like score cards require a calculated field to be added, which isn't an easy option for customers.