Metatron-discovery: Improved sorting order when viewing data (Metatron engine type)

Created on 2 Nov 2018  ยท  8Comments  ยท  Source: metatron-app/metatron-discovery

Is your feature request related to a problem? Please describe.
๋ฐ์ดํ„ฐ์†Œ์Šค ์ƒ์„ฑ ์‹œ '๋ฉ”ํƒ€ํŠธ๋ก  ์—”์ง„' ํƒ€์ž…์œผ๋กœ ์ƒ์„ฑ ์‹œ ์ปฌ๋Ÿผ ๋ฆฌ์ŠคํŠธ ์ˆœ์„œ๊ฐ€..
Druid ์— ๋„ฃ์€ ์ˆœ์„œ์™€ ๋งž๊ฒŒ ์ •๋ ฌํ•˜๊ณ  ์‹ถ์Šต๋‹ˆ๋‹ค.
ํ˜„์žฌ ๋ฉ”ํƒ€ํŠธ๋ก  UI์—์„œ๋Š” ์•ŒํŒŒ๋ฒณ์œผ๋กœ ์ •๋ ฌ๋˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค.
(ํ•ด๋‹น๋‚ด์šฉ์€ DTํฌํƒˆ์—์„œ ์š”๊ตฌ์‚ฌํ•ญ์„ ๋‚ธ ๋‚ด์šฉ์ž…๋‹ˆ๋‹ค.)

Describe the solution you'd like
๋ฉ”ํƒ€ํŠธ๋ก  ์„œ๋ฒ„์—์„œ Druid์˜ ์ปฌ๋Ÿผ ์ •๋ณด๋ฅผ ๊ฐ€์ ธ์˜ฌ๋•Œ
Druid์— ๋„ฃ์€ ์ปฌ๋Ÿผ ์ˆœ์„œ๋Œ€๋กœ ๊ฐ€์ ธ์™€์•ผ ํ•  ๊ฒƒ ๊ฐ™์Šต๋‹ˆ๋‹ค. (ex. segment meta query)

Sorting ๊ธฐ๋ณธ๊ฐ’์ด ์žˆ์–ด์•ผ ํ•จ

  • ๊ธฐ๋ณธ ์ •๋ ฌ ์˜ค๋ฆ„/๋‚ด๋ฆผ (Druid์— ๋„ฃ์€ ์ˆœ์„œ๋ฅผ ์˜๋ฏธํ•จ)

ํ•˜๋‹จ์˜ ๋ถ€๋ถ„์— ๋Œ€ํ•ด์„œ Sorting๊ธฐ๋Šฅ์„ ์ œ๊ณตํ•ด์•ผ ํ•จ

  • ์ฐจํŠธ ์ƒ์„ธ ์ปฌ๋Ÿผ ๋ฆฌ์ŠคํŠธ
  • ์Šคํ‚ค๋งˆ๋ธŒ๋ผ์šฐ์ ธ ๋‚ด ์ปฌ๋Ÿผ ๋””ํ…Œ์ผ
  • ๋ฐ์ดํ„ฐ ๋ฏธ๋ฆฌ๋ณด๊ธฐ

Additional context
Druid ์ฝ˜์†” ๋‚ด ์ •๋ ฌ ์ˆœ์„œ ํ™”๋ฉด
image 22

'๋ฉ”ํƒ€ํŠธ๋ก  ์—”์ง„' ํƒ€์ž…์œผ๋กœ ๋ฐ์ดํ„ฐ๋ฅผ ์ ์žฌํ•œ ๊ฒฝ์šฐ์˜ ์ฐจํŠธ ์ƒ์„ธ ํ™”๋ฉด
image

'๋ฉ”ํƒ€ํŠธ๋ก  ์—”์ง„' ํƒ€์ž…์ด ์•„๋‹Œ ๋‹ค๋ฅธ ํƒ€์ž…์œผ๋กœ ๋ฐ์ดํ„ฐ๋ฅผ ์ ์žฌํ•œ ๊ฒฝ์šฐ์˜ ์ฐจํŠธ ์ƒ์„ธ ํ™”๋ฉด
image

enhancement @dashboard @datasource awaiting feedback

Most helpful comment

@kyungtaak
๋ฐ์ดํ„ฐ ์†Œ์Šค ์ƒ์„ธ > ์ปฌ๋Ÿผ ์ˆ˜์ •ํ™”๋ฉด์—๋„ ์ •๋ ฌ ๊ธฐ๋Šฅ ๋„ฃ๋Š” ๊ฒƒ์„ ๊ณ ๋ คํ•˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค. ๊ณง ์ •๋ฆฌํ•ด์„œ ๊ณต์œ ๋“œ๋ฆฌ๊ฒ ์Šต๋‹ˆ๋‹ค.

All 8 comments

@AnnieHwang @metatron-app/design ์šฐ๋ฆฌ ์ œํ’ˆ๋‚ด ๋ชฉ๋ก ์ •์ฑ…์— ๋Œ€ํ•ด ๋จผ์ € ํ™•์ธ์ด ํ•„์š”ํ• ๊ฒƒ ๊ฐ™์•„์š”. ์ด๋ฒˆ ๊ธฐํšŒ์—
๊ทธ๋ฆฌ๊ณ  ๋ชฉ๋ก ๊ด€๋ จ ๋””์ž์ธ ๊ฒ€์ˆ˜์™€, ๊ฒ€์ƒ‰ ๋ฒ„ํŠผ์„ ๋„ฃ๋Š”๊ฒƒ๋„ ๊ดœ์ฐฌ์„ ๊ฒƒ ๊ฐ™์€๋ฐ์š”. ํ™•์ธ ๋ถ€ํƒ๋“œ๋ฆฝ๋‹ˆ๋‹ค.

@kyungtaak @minjung-cho ํ•ด๋‹น ๋‚ด์šฉ ํ™•์ธํ•ด๋ณด๋„๋ก ํ•˜๊ฒ ์Šต๋‹ˆ๋‹ค.

@AnnieHwang #719 ์ด์Šˆ์—์„œ ์ด์Šˆ๊ฐ€ ๋˜์—ˆ๋˜ ์‚ฌํ•ญ์ฒ˜๋Ÿผ ๋ฐ์ดํ„ฐ ์†Œ์Šค ์ƒ์„ธ > ์ปฌ๋Ÿผ ์ˆ˜์ •์‹œ์—๋„ ์ˆœ์„œ ๋ณ€๊ฒฝ์„ ๋‘˜ ๊ฒƒ์ธ์ง€ ์ถ”๊ฐ€ ํ™•์ธ ๋ถ€ํƒ๋“œ๋ฆฝ๋‹ˆ๋‹ค.

@kyungtaak
๋ฐ์ดํ„ฐ ์†Œ์Šค ์ƒ์„ธ > ์ปฌ๋Ÿผ ์ˆ˜์ •ํ™”๋ฉด์—๋„ ์ •๋ ฌ ๊ธฐ๋Šฅ ๋„ฃ๋Š” ๊ฒƒ์„ ๊ณ ๋ คํ•˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค. ๊ณง ์ •๋ฆฌํ•ด์„œ ๊ณต์œ ๋“œ๋ฆฌ๊ฒ ์Šต๋‹ˆ๋‹ค.

@AnnieHwang @kyungtaak @minjung-cho
๋‹ค์Œ๊ณผ ๊ฐ™์ด ์ •๋ฆฌํ•˜์˜€์Šต๋‹ˆ๋‹ค.

  1. ๊ธฐ๋ณธ ๊ทœ์น™
    651
    ์ •๋ ฌ์‹œ ์˜ต์…˜์˜ ํ•ญ๋ชฉ์˜ ๋…ธ์ถœ ํ‘œํ˜„์„ ๊ฐœ์„ ํ•˜๊ณ ์ž ํ•ฉ๋‹ˆ๋‹ค.
    ๊ทธ๋ฆผ ๋‚ด '๊ฐ™์€ ์˜ต์…˜, ๋‹ค๋ฅธ ํ‘œํ˜„ ๋น„๊ต'๋ฅผ ์‚ดํŽด๋ณด์‹œ๋ฉด ๋งจ ์˜ค๋ฅธ์ชฝ์ด ๊ฐ€์žฅ ๋ˆˆ์— ํ•ญ๋ชฉ์ด ์ž˜ ๋“ค์–ด์˜ต๋‹ˆ๋‹ค.
    ๋•Œ๋ฌธ์— ์šฐ๋ฆฌ ์„œ๋น„์Šค ๋‚ด ๊ณตํ†ต ๊ทœ์น™์œผ๋กœ ๊ฐ€์ ธ๊ฐ€๊ณ ์ž ํ•ฉ๋‹ˆ๋‹ค. (๋†“์นœ ํ™”๋ฉด์ด ์žˆ๋‹ค๋ฉด ๋ง์”€ํ•ด์ฃผ์„ธ์š”)

  2. Dashboard ์ˆ˜์ •
    651dashboard

  3. Create dashboard > Setup essential filters: ํ•ญ๋ชฉ ์ˆ˜์ •
  4. Dashboard ๋ชฉ๋ก : ํ•ญ๋ชฉ ์ˆ˜์ •
  5. Chart > Filter : ํ•ญ๋ชฉ ์ˆ˜์ •
  6. Chart > ์„ ๋ฐ˜ Dimension/Measure > Align : ํ•ญ๋ชฉ ์ˆ˜์ •
  7. Chart ์ขŒ์ธก Dimension/Measure list : ์ •๋ ฌ ์ถ”๊ฐ€
  8. Chart > Custom column : ์ •๋ ฌ ์ถ”๊ฐ€
  9. Dashboard > Datasource > Column detail: ์ •๋ ฌ ์ถ”๊ฐ€

  10. Workbook ์ˆ˜์ •
    651workbook

  11. Workbench ์ขŒ์ธก Table > Column ๋ชฉ๋ก : ์ •๋ ฌ ์ถ”๊ฐ€
  12. Workbench > Scheme Information > Columns : ์ •๋ ฌ ์ถ”๊ฐ€

  13. Datasource ์ˆ˜์ •, ์„ค์ • ์ถ”๊ฐ€
    651datasource

  14. Create Datasource > configure the schema : ์ •๋ ฌ ์„ค์ • ์ถ”๊ฐ€
  15. Datasource > Column detail > Configure the schema : ์ •๋ ฌ ์„ค์ • ์ถ”๊ฐ€ (์ •๋ ฌ ์„ค์ •์‹œ ํ•ด๋‹น ์ˆœ์„œ๊ฐ€ ๊ธฐ๋ณธ ๋ฐ์ดํ„ฐ ์ •๋ ฌ์ˆœ์„œ๊ฐ€ ๋จ)
  16. Datasource > Column detail: ์ •๋ ฌ ์ถ”๊ฐ€ : ์ •๋ ฌ ์ถ”๊ฐ€

๋ฐ์ดํ„ฐ์†Œ์Šค ํ™”๋ฉด์— ์ •๋ ฌ ์„ค์ • ์ถ”๊ฐ€์ด๊ธฐ ๋•Œ๋ฌธ์— ์™€์ด์–ดํ”„๋ ˆ์ž„์„ ์žฌ์ •๋ฆฌํ–ˆ์Šต๋‹ˆ๋‹ค. (์œ„์™€ ๋™์ผ ๋‚ด์šฉ์ž…๋‹ˆ๋‹ค.)

  1. ๋ฐ์ดํ„ฐ์†Œ์Šค ์ƒ์„ฑ > ์ปฌ๋Ÿผ ์Šคํ‚ค๋งˆ ์„ค์ • ๋‹จ๊ณ„์— ์ •๋ ฌ ์„ค์ • ์ถ”๊ฐ€
    2019-01-18 6 37 28

  2. ๋ฐ์ดํ„ฐ์†Œ์Šค ์ƒ์„ธ์ •๋ณด > ์ปฌ๋Ÿผ ์Šคํ‚ค๋งˆ ์„ค์ •ํ™”๋ฉด์— ์ •๋ ฌ ์„ค์ • ์ถ”๊ฐ€
    2019-01-18 7 10 33

  3. ๋ฐ์ดํ„ฐ์†Œ์Šค ์ƒ์„ธ์ •๋ณด > ์ปฌ๋Ÿผ์ƒ์„ธ์ •๋ณด์— ์ปฌ๋Ÿผ์ •๋ ฌ ์ถ”๊ฐ€
    2019-01-18 6 37 35

์ฐธ๊ณ ๋ฅผ ๋ถ€ํƒ๋“œ๋ฆฝ๋‹ˆ๋‹ค.

@AnnieHwang @kyungtaak
'Workbench > Scheme Information > Columns : ์ •๋ ฌ ์ถ”๊ฐ€'๋ฅผ ์š”์ฒญ๋“œ๋ ธ๋Š”๋ฐ ์ด ํ™”๋ฉด์— ํˆดํŒ์ด๋‚˜ ๋ ˆ์ด์–ด๋ฅผ ์ถ”๊ฐ€ํ•˜๋Š” ๊ฒƒ์ด ๊ตฌ์กฐ์ƒ ์–ด๋ ค์šธ๋“ฏ ํ•ฉ๋‹ˆ๋‹ค.
์ด ์š”์ฒญ์€ ์ผ๋‹จ ๋ณด๋ฅ˜ ๋ถ€ํƒ๋“œ๋ฆฝ๋‹ˆ๋‹ค.

@AnnieHwang ์ •๋ ฌ๊ด€๋ จ ์ถ”๊ฐ€๋˜๋Š” ๋ถ€๋ถ„ ๋””์ž์ธ ๊ณต์œ ๋“œ๋ฆฝ๋‹ˆ๋‹ค
์ •๋ ฌ ๋“ค์–ด๊ฐ€๋Š” ํƒ€์ž…์€ 3๊ฐ€์ง€ ์žˆ์Šต๋‹ˆ๋‹ค. ์•„๋ž˜ ํ™”๋ฉด ์ฐธ๊ณ  ๋ถ€ํƒ๋“œ๋ ค์š”
-ํ•„ํ„ฐ๋ง์˜์—ญ ๋˜๋Š” ํŒจ๋„์— ๋“ค์–ด๊ฐ€๋Š”๊ฒฝ์šฐ
-๊ทธ๋ฆฌ๋“œํ—ค๋”์— ๋“ค์–ด๊ฐ€๋Š” ๊ฒฝ์šฐ
-์ •๋ ฌ ์„ค์ •ํ•˜๋Š” ๊ฒฝ์šฐ

Dashboard & chart
Chart ์ขŒ์ธก Dimension/Measure list : ์ •๋ ฌ ์ถ”๊ฐ€
image

Chart > Custom column : ์ •๋ ฌ ์ถ”๊ฐ€
image

Dashboard > Datasource > Column detail: ์ •๋ ฌ ์ถ”๊ฐ€
image

Workbench
Workbench ์ขŒ์ธก Table > Column ๋ชฉ๋ก : ์ •๋ ฌ ์ถ”๊ฐ€
image

Datasource
๋ฐ์ดํ„ฐ์†Œ์Šค ์ƒ์„ฑ > ์ปฌ๋Ÿผ ์Šคํ‚ค๋งˆ ์„ค์ • ๋‹จ๊ณ„์— ์ •๋ ฌ ์„ค์ • ์ถ”๊ฐ€
image

๋ฐ์ดํ„ฐ์†Œ์Šค ์ƒ์„ธ์ •๋ณด > ์ปฌ๋Ÿผ ์Šคํ‚ค๋งˆ ์„ค์ •ํ™”๋ฉด์— ์ •๋ ฌ ์„ค์ • ์ถ”๊ฐ€
image

๋ฐ์ดํ„ฐ์†Œ์Šค ์ƒ์„ธ์ •๋ณด > ์ปฌ๋Ÿผ์ƒ์„ธ์ •๋ณด์— ์ปฌ๋Ÿผ์ •๋ ฌ ์ถ”๊ฐ€
image

Was this page helpful?
0 / 5 - 0 ratings

Related issues

sshtel picture sshtel  ยท  3Comments

qinchaofeng picture qinchaofeng  ยท  8Comments

Taehui picture Taehui  ยท  3Comments

jeongeunkwon picture jeongeunkwon  ยท  5Comments

ufoscw picture ufoscw  ยท  8Comments