Insight Issue: Duplicate values due to whitespace replaced with underscore

DanielStormApps commented 9 months ago

Values with whitespaces are having their whitespaces replaced with underscores, _. This is resulting in double the values as iOS 17 and iOS_17 are unique from one another, see screenshot. This is occurring across all values, not just majorSystemVersion, which results in inaccurate data across all insights.

Insight ID: CA9B1C72-0492-4A92-8A10-2B20430D3CE8

{
  "aggregations": [
    {
      "fieldName": "clientUser",
      "name": "count",
      "type": "thetaSketch"
    }
  ],
  "baseFilters": "thisOrganization",
  "dimension": {
    "dimension": "majorSystemVersion",
    "outputName": "majorSystemVersion",
    "type": "default"
  },
  "granularity": "all",
  "metric": {
    "metric": "count",
    "type": "numeric"
  },
  "queryType": "topN",
  "threshold": 200
}

double-the-values

Cykelero commented 9 months ago

Yikes, that's pretty serious. I really hope they'll be able to fix data retroactively.

winsmith commented 8 months ago

They were able to, for systemVersions and all other default keys :)

TelemetryDeck / Issues

Insight Issue: Duplicate values due to whitespace replaced with underscore #340