Fix average order value graph flattening out to value 0

[beamylake]

Hello,

we have run into the same problem as mentioned in #7851

When looking at Ecommerce/Overview the average order value graph sticks to zero regardless that the summary and API call report a value other than zero.

Our Matomo (3.13) setup is still the same as described in #15240

Please let me know, if you need any further information and thanks for your efforts in advance!

[tsteur]

Might be related to #15200 too? @sgiehl ?

[beamylake]

If this question was directed to me - no, we don't experience anything mentioned in #15200

[tsteur]

I can reproduce this... Might have a chance to look at this while working on #11615

[beamylake]

Looks like this yet might be related to #15200

When using English all numbers are correct (the number and formatting of the number) - but when using German as language setting, the numbers in the visitor overview are misformatted and partly wrong rounded.

But this partly also applies to the Ecommerce overview: For example, in English the conversion rate is shown with 0,5% (which is correct) and in German it is shown with 0%

[beamylake]

FYI: The release of 3.13.1 fixed issue #15200
Unfortunately this problem still exists.

[sgiehl]

@tsteur The problem for that is again related to the number formatting. The evolution chart fetches the report formatted, so the values for order value are somewhat like $123.45. But when generating the data for the graph the numbers are casted to float here:

matomo/plugins/CoreVisualizations/JqplotDataGenerator/Chart.php

Lines 69 to 71 in 1155273

	array_walk($data, function (&$v) {
	$v = (float) Common::forceDotAsSeparatorForDecimalPoint($v);
	});

This results in 0 values for strings not starting with a number.
This might not be as easy to fix as I thought. First tried to simply fetch the report without formatted numbers. That actually fixes the problem for the order value. But that creates a problem with any rates displayed. e.g. a conversion rate would than show 0.04 instead of 4, as the number is not formatted anymore. Tried format_metrics = bc, but that doesn't do the trick either...

[tsteur]

@sgiehl I suppose we can't simply replace $€ etc with an empty string there? Would this help (of course not best solution but if it mixes most issues might be a solution.) or in case we know it is supposed to be a number we could keep only numbers and dots and remove everything else? But I suppose a number may look like $123,45 when German is selected and it all doesn't work?

[sgiehl]

The german format would actually be catched by forceDotAsSeparatorForDecimalPoint, as it would replace the , with .. On the other side might that replacement break bigger numbers like 2.000,44 or even other language formats that use their own chars as floating point or thousands separator. In addition there is not only the German format and not only $ and €. Every currency might have it's own translation for each language.
And that actually does not only happen for currency values. If you switch the language to Euskara the same problem appears for the conversion rate. Euskara uses % #,##0 for formatting percentage, so it has the same problem.

Imho it would be correct to fetch the numbers unformatted for building any chart. Guess the only problem would be the percentage metrics, that would actually be calculated while formatting...
Maybe we need to think about changing all those metrics, so they do not do a calculation while formatting?

[tsteur]

Maybe we need to think about changing all those metrics, so they do not do a calculation while formatting?

That would be great 👍

[Starker3]

We have another user experiencing this issue.

[atom-box]

A user reports:

"We are not getting the actual average value graph for the customer,
The average value according to the site is $1435 but the graph shows a flat zero every month."