Sh4pe · May 31, 2021 08:45
diff --git a/cardinality.flux b/cardinality.flux
 // Count unique values for each tag in a bucket
 import "influxdata/influxdb/schema"
 
 cardinalityByTag = (bucket) =>
  schema.tagKeys(bucket: bucket)
    |> map(fn: (r) => ({
      tag: r._value,
      _value:
        if contains(set: ["_stop","_start"], value:r._value) then 0
        else (schema.tagValues(bucket: bucket, tag: r._value)
          |> count()
          |> findRecord(fn: (key) => true, idx: 0))._value
    }))
    |> group(columns:["tag"])
    |> sum()
 
 cardinalityByTag(bucket: "statisticaldata_downsampled_1h")
diff --git a/configs.md b/configs.md
	// Count unique values for each tag in a bucket
	import "influxdata/influxdb/schema"

	cardinalityByTag = (bucket) =>
	schema.tagKeys(bucket: bucket)
	\|> map(fn: (r) => ({
	tag: r._value,
	_value:
	if contains(set: ["_stop","_start"], value:r._value) then 0
	else (schema.tagValues(bucket: bucket, tag: r._value)
	\|> count()
	\|> findRecord(fn: (key) => true, idx: 0))._value
	}))
	\|> group(columns:["tag"])
	\|> sum()

	cardinalityByTag(bucket: "statisticaldata_downsampled_1h")
No results found