-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathbatting.view.lookml
97 lines (73 loc) · 1.43 KB
/
batting.view.lookml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
- view: batting
sql_table_name: stats.batting
fields:
- dimension: 2_b
type: number
sql: ${TABLE}.2B
- dimension: 3_b
type: number
sql: ${TABLE}.3B
- dimension: ab
type: number
sql: ${TABLE}.AB
- dimension: bb
type: number
sql: ${TABLE}.BB
- dimension: cs
type: number
sql: ${TABLE}.CS
- dimension: g
type: number
sql: ${TABLE}.G
- dimension: gidp
type: string
sql: ${TABLE}.GIDP
- dimension: h
type: number
sql: ${TABLE}.H
- dimension: hbp
type: string
sql: ${TABLE}.HBP
- dimension: hr
type: number
sql: ${TABLE}.HR
- dimension: ibb
type: string
sql: ${TABLE}.IBB
- dimension: lg_id
type: string
sql: ${TABLE}.lgID
- dimension: player_id
type: string
sql: ${TABLE}.playerID
- dimension: r
type: number
sql: ${TABLE}.R
- dimension: rbi
type: number
sql: ${TABLE}.RBI
- dimension: sb
type: number
sql: ${TABLE}.SB
- dimension: sf
type: string
sql: ${TABLE}.SF
- dimension: sh
type: string
sql: ${TABLE}.SH
- dimension: so
type: number
sql: ${TABLE}.SO
- dimension: stint
type: number
sql: ${TABLE}.stint
- dimension: team_id
type: string
# hidden: true
sql: ${TABLE}.teamID
- dimension: year_id
type: number
sql: ${TABLE}.yearID
- measure: count
type: count
drill_fields: [teams.name, teams.team_id]