-
Notifications
You must be signed in to change notification settings - Fork 0
/
events.view.lkml
70 lines (60 loc) · 1.06 KB
/
events.view.lkml
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
view: events {
sql_table_name: demo_db.events ;;
dimension: id {
primary_key: yes
type: number
sql: ${TABLE}.id ;;
}
##git change
## newer git change
## cli git change
dimension_group: created {
type: time
timeframes: [
raw,
time,
date,
week,
month,
quarter,
year
]
sql: ${TABLE}.created_at ;;
html: {% assign nowunix = now | date: '%s' %}
{{nowunix}} ;;
}
dimension_group: current {
type: time
timeframes: [
raw,
time,
date,
week,
month,
quarter,
year
]
sql: current_date ;;
html: {% assign nowunix = {{value}} | date: '%s' %}
{{nowunix}} ;;
}
dimension: test{}
dimension: type_id {
type: number
sql: ${TABLE}.type_id ;;
}
dimension: user_id {
type: number
# hidden: yes
sql: ${TABLE}.user_id ;;
}
dimension: value {
type: string
sql: ${TABLE}.value ;;
}
#sldjjsf
measure: count {
type: count
drill_fields: [id, users.last_name, users.first_name, users.id]
}
}