Sparklines in Ecommerce widget broken when using Comparison with Date Range

[Starker3]

When Selecting a Date Range and comparing that Date Range with another preiod, the Ecommerce Widget sparklines show the incorrect values for the sparkline chart:

In the demo the issue is the same, but with the added issue that the sparklines are also flat:

To reproduce this:

1. add the Ecommerce Overview widget to the Dashboard
2. Select a Date Range and Select "Compare" to previous period
3. Click on a metric that contains Revenue
   https://demo.matomo.cloud/index.php?module=CoreHome&action=index&idSite=1&period=day&date=yesterday#?period=range&date=2022-10-01,2022-11-01&category=Dashboard_Dashboard&subcategory=1&comparePeriods%5B%5D=range&compareDates%5B%5D=2022-08-30,2022-09-30

[peterhashair]

@Starker3 thank you for reporting this, I can reproduce this on our demo or locally. I believe there is a regression there.

[peterhashair]

It seems like when comparing, the revenue on the dataTable covert to string 'NZ$123' instead of float leading to a graphic loading error.

[sgiehl]

might be related to #15349

[Starker3]

We have another email from a customer asking about this issue today.

[AdamMcAddEm]

I am also dealing with this issue. Impacts a parent company that leverages Matomo heavily for ecommerce with +30 brands and teams.