API
API
MeasureMeta

MeasureMeta

์ธก์ •๊ฐ’(Measure) ์ •์˜ ํƒ€์ž….

NameTypeDescription
aggregate'sum' | 'avg' | 'min' | 'max' | 'count' | 'distinct' | 'first' | 'last' | 'p25' | 'p50' | 'p75' | 'product' | 'stdev' | 'stdevp' | 'var' | 'varp'์ง‘๊ณ„ ํ•จ์ˆ˜ ํƒ€์ž….
  • 'sum': ํ•ฉ๊ณ„
  • 'avg': ํ‰๊ท 
  • 'min': ์ตœ์†Ÿ๊ฐ’
  • 'max': ์ตœ๋Œ“๊ฐ’
  • 'count': ๊ฑด์ˆ˜ (null/NaN ์ œ์™ธ)
  • 'distinct': ๊ณ ์œ ๊ฐ’ ์ˆ˜
  • 'first': ๊ทธ๋ฃน ๋‚ด ์ฒซ ๋ฒˆ์งธ ๊ฐ’ (์›๋ณธ ๋ฐ์ดํ„ฐ ์ˆœ์„œ ๊ธฐ์ค€, ๊ฒฐ์ •๋ก ์ )
  • 'last': ๊ทธ๋ฃน ๋‚ด ๋งˆ์ง€๋ง‰ ๊ฐ’ (์›๋ณธ ๋ฐ์ดํ„ฐ ์ˆœ์„œ ๊ธฐ์ค€, ๊ฒฐ์ •๋ก ์ )
  • 'p25': 25๋ฐฑ๋ถ„์œ„์ˆ˜ (์„ ํ˜• ๋ณด๊ฐ„)
  • 'p50': 50๋ฐฑ๋ถ„์œ„์ˆ˜ (์ค‘์•™๊ฐ’, ์„ ํ˜• ๋ณด๊ฐ„)
  • 'p75': 75๋ฐฑ๋ถ„์œ„์ˆ˜ (์„ ํ˜• ๋ณด๊ฐ„)
  • 'product': ๊ณฑ (๊ทธ๋ฃน ๋‚ด ๋ชจ๋“  ๊ฐ’์˜ ๊ณฑ)
  • 'stdev': ํ‘œ๋ณธ ํ‘œ์ค€ํŽธ์ฐจ (n-1 ๊ธฐ์ค€)
  • 'stdevp': ํ‘œ์ค€ํŽธ์ฐจ (๋ชจ์ง‘๋‹จ, n ๊ธฐ์ค€)
  • 'var': ํ‘œ๋ณธ ๋ถ„์‚ฐ (n-1 ๊ธฐ์ค€)
  • 'varp': ๋ถ„์‚ฐ (๋ชจ์ง‘๋‹จ, n ๊ธฐ์ค€)
first/last๋Š” ๋‹จ์ผ ์Šค๋ ˆ๋“œ ์ˆœ์ฐจ ์ˆœํšŒ(row 0 โ†’ N)๋กœ ์ˆ˜์ง‘๋˜๋ฏ€๋กœ, ๋™์ผํ•œ ์†Œ์Šค ๋ฐ์ดํ„ฐ์— ๋Œ€ํ•ด ํ•ญ์ƒ ๊ฐ™์€ ๊ฒฐ๊ณผ๋ฅผ ๋ณด์žฅํ•œ๋‹ค (๊ฒฐ์ •๋ก ์ ).
๋ชจ๋“  ์ง‘๊ณ„ ํ•จ์ˆ˜๋Š” null/undefined/NaN ๊ฐ’์„ ์ œ์™ธํ•˜๊ณ  ๊ณ„์‚ฐ๋œ๋‹ค.
descirptionstring (opens in a new tab)
namestring (opens in a new tab)
sourcestring (opens in a new tab) | (row: any (opens in a new tab)) => any (opens in a new tab)
type'f64' | 'i32' | 'str' | 'date'์ธก์ •๊ฐ’ ์ปฌ๋Ÿผ ๋ฐ์ดํ„ฐ ํƒ€์ž….
  • 'f64'/'i32': ๋ชจ๋“  aggregate ์ง€์›.
  • 'i64': 64-bit ์ •์ˆ˜ ๋ˆ„์  (BigInt). sum/min/max/count ๋งŒ ์ง€์› โ€” 1๊ฒฝ(10^16) ์ด์ƒ์˜ ์ •์ˆ˜๋„ ์ •๋ฐ€๋„ ์†์‹ค ์—†์ด ํ•ฉ์‚ฐ.
  • 'str'/'date': 'count' / 'distinct' aggregate ๋งŒ ์ง€์› (Excel Power Pivot ๋ชจ๋ธ).
[TODO]: ํ–ฅํ›„ 'i64' ์ง€์›์ด ์•ˆ์ •ํ™”๋˜๋ฉด, 'i64'๋„ role=measure์—์„œ aggregate์— ๋”ฐ๋ผ ์ง€์› ์—ฌ๋ถ€๊ฐ€ ๋‹ฌ๋ผ์ง€๋„๋ก canMeasureMeta() ๋กœ์ง ์ˆ˜์ • ๊ณ ๋ ค. ํ˜„์žฌ๋Š” ๊ฐ„๋‹จํžˆ i64๋Š” sum/min/max/count ๋งŒ ํ—ˆ์šฉํ•˜๋„๋ก isI64Aggregate()๋กœ ๋ถ„๋ฆฌํ•˜์—ฌ ๊ด€๋ฆฌ.]