VisActor VBI
  • Deutsch

      • Aggregation

      avg

      Select-Avg-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-avg",
  "description": "Select-Avg-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "salary",
        "aggr": {
          "func": "avg"
        },
        "alias": "avg_salary"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}

      count_distinct

      Select-Count-Distinct-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-count-distinct",
  "description": "Select-Count-Distinct-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "department",
        "aggr": {
          "func": "count_distinct"
        },
        "alias": "distinct_departments"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    },
    {
      "id": 6,
      "name": "Frank",
      "age": 28,
      "department": "Engineering",
      "salary": 7000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}

      count

      Select-Count-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-count",
  "description": "Select-Count-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "id",
        "aggr": {
          "func": "count"
        },
        "alias": "total_count"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}

      max

      Select-Max-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-max",
  "description": "Select-Max-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "salary",
        "aggr": {
          "func": "max"
        },
        "alias": "max_salary"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}

      median

      Select-Median-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-median",
  "description": "Select-Median-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "salary",
        "aggr": {
          "func": "median"
        },
        "alias": "salary_median"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    },
    {
      "id": 6,
      "name": "Frank",
      "age": 28,
      "department": "Engineering",
      "salary": 7000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}

      min

      Select-Min-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-min",
  "description": "Select-Min-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "salary",
        "aggr": {
          "func": "min"
        },
        "alias": "min_salary"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}

      quantile

      Select-Quantile-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-quantile",
  "description": "Select-Quantile-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "salary",
        "aggr": {
          "func": "quantile",
          "quantile": 0.9
        },
        "alias": "salary_quantile"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    },
    {
      "id": 6,
      "name": "Frank",
      "age": 28,
      "department": "Engineering",
      "salary": 7000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}

      stddev

      Select-Stddev-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-stddev",
  "description": "Select-Stddev-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "salary",
        "aggr": {
          "func": "stddev"
        },
        "alias": "salary_stddev"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    },
    {
      "id": 6,
      "name": "Frank",
      "age": 28,
      "department": "Engineering",
      "salary": 7000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}

      sum

      Select-Sum-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-sum",
  "description": "Select-Sum-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "salary",
        "aggr": {
          "func": "sum"
        },
        "alias": "total_salary"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}

      variance

      Select-Variance-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-variance",
  "description": "Select-Variance-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "salary",
        "aggr": {
          "func": "variance"
        },
        "alias": "salary_variance"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    },
    {
      "id": 6,
      "name": "Frank",
      "age": 28,
      "department": "Engineering",
      "salary": 7000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}

      variancePop

      Select-VariancePop-Beispiel

      import { VQueryResultRender } from '@components'

export default () => {
  const vqueryConfig = {
  "datasetId": "select-aggregation-variance-pop",
  "description": "Select-VariancePop-Beispiel",
  "vquery": {
    "select": [
      {
        "field": "salary",
        "aggr": {
          "func": "variance_pop"
        },
        "alias": "salary_variance_pop"
      }
    ]
  },
  "dataset": [
    {
      "id": 1,
      "name": "Alice",
      "age": 25,
      "department": "HR",
      "salary": 5000
    },
    {
      "id": 2,
      "name": "Bob",
      "age": 30,
      "department": "Engineering",
      "salary": 8000
    },
    {
      "id": 3,
      "name": "Charlie",
      "age": 35,
      "department": "Engineering",
      "salary": 9000
    },
    {
      "id": 4,
      "name": "David",
      "age": 40,
      "department": "HR",
      "salary": 6000
    },
    {
      "id": 5,
      "name": "Eve",
      "age": 22,
      "department": "Marketing",
      "salary": 4000
    },
    {
      "id": 6,
      "name": "Frank",
      "age": 28,
      "department": "Engineering",
      "salary": 7000
    }
  ],
  "schema": [
    {
      "name": "id",
      "type": "number"
    },
    {
      "name": "name",
      "type": "string"
    },
    {
      "name": "age",
      "type": "number"
    },
    {
      "name": "department",
      "type": "string"
    },
    {
      "name": "salary",
      "type": "number"
    }
  ]
}

  return <VQueryResultRender vqueryConfig={vqueryConfig} />
}