# 여러개 바 리스트 그리기 BarList

**URL:** <https://ask.selectfromuser.com/t/barlist/42>\
**Category:** 사용 팁\
**Created:** [6월 28, 2023, 10:11오전 UTC](https://ask.selectfromuser.com/t/barlist/42 "2023-06-28T10:11:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jhlee](https://yyz2.discourse-cdn.com/flex032/user_avatar/ask.selectfromuser.com/jhlee/32/20_2.png) [@jhlee](https://ask.selectfromuser.com/u/jhlee)\
**Post date:** [6월 28, 2023, 10:11오전 UTC](https://ask.selectfromuser.com/t/barlist/42/1 "2023-06-28T10:11:33Z")

</div>

GA, plausible, Amplitude등 흔히 볼 수 있는 도표를 그리는 YML을 공유합니다.

```yaml
resource: mysql.qa
display: metric
sql: > 
  SELECT COALESCE(`type`, 'NONE') AS t, COUNT(id) as 'c', id
  FROM properties2
  GROUP BY `type`
  ORDER BY 2 DESC
metricOptions:
  type: bar
  # type: category
  name: t
  # href: "/detail?id={{id}}"
  value: c
  nameLabel: Source
  valueLabel: Visits
  total: 전체 방문

```

href 넣는 경우 클릭하면 해당 페이지로 이동합니다.