Actor picture

Aggregate Fields

pocesar/aggregate-fields

Create an overview of a dataset by aggregating the possible variations from the selected fields. Useful for checking the consistency of data used together with the Results Checker actor.

No credit card required

Author's avatarPaulo Cesar
  • Modified
  • Users4
  • Runs44

Create an overview of a dataset by aggregating the possible variations from the selected fields Useful for checking the consistency of data used together with the Results Checker actor

Usage

Dataset format

[{
  "type": "type-1",
  "categories": [
    "cat 1",
    "cat 2"
  ],
  "n": 1
},{
  "type": "type-2",
  "categories": [
    "cat 4",
    "cat 5"
  ],
  "n": 2
}]

INPUT

{
  "datasetId": "defaultDatasetId",
  "fields": [
    "type",
    "categories",
    "n"
  ],
  "split": {
    "categories": " ",
    "type": "-"
  }
}

OUTPUT

{
  "categories": {
    "values": [
      "cat",
      "1",
      "2",
      "4",
      "5"
    ],
    "count": 5,
    "min": 1,
    "max": 3,
    "average": 2
  },
  "type": {
    "values": [
      "type",
      "1",
      "2"
    ],
    "count": 3,
    "min": 1,
    "max": 4,
    "average": 2
  },
  "n": {
    "values": [
      1,
      2
    ],
    "count": 2,
    "min": 1,
    "max": 2,
    "average": 1
  }
}

License

Apache 2.0

Industries

See how Aggregate Fields is used in industries around the world