Values in Total fields of tabular DataLens charts mismatch those in Yandex Metrica
Issue description
DataLens uses a connection to Yandex Metrica data.
My tabular chart in DataLens and data from Yandex Metrica show different values in Total fields.
Solution
Such a behavior results from Yandex Metrica mechanics. When you request data over the API, Yandex Metrica returns an approximate result.
Accuracy of the provided data is also affected by sampling on the Yandex Metrica side.
To make sure that additive metrics show correct total values, change the accuracy in the connection settings to 100%.
A direct connection to Yandex Metrica has several limitations. We recommend exporting raw data from Yandex Metrica to an intermediate database. For example, to export and/or replicate data from Yandex Metrica, you can use the ClickHouse database.
Once you export the data to an intermediate database, you can set up a connection to it from DataLens.
If the issue persists
If the above actions didn't help, create a request for support.
In the request, specify the following information:
- Link to the problem object from the browser address bar.
- Full text of the error message with the Request ID content.
- HAR file with the recorded results of browser interaction with DataLens servers.