-
Notifications
You must be signed in to change notification settings - Fork 6
/
Copy pathmaestroqa.custom_options.view.lkml
67 lines (58 loc) · 1.45 KB
/
maestroqa.custom_options.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
view: custom_options {
sql_table_name: maestro.custom_options ;;
dimension: option_id {
description: "Identifier of this option"
primary_key: yes
type: string
sql: ${TABLE}.option_id ;;
}
dimension: label {
description: "String label of this option"
type: string
sql: ${TABLE}.label ;;
}
dimension: points {
description: "How many points this option is worth"
type: number
sql: ${TABLE}.points ;;
}
dimension: question_id {
description: "The identifier of the question that this option belongs to"
type: string
# hidden: yes
sql: ${TABLE}.question_id ;;
}
dimension: section_id {
description: "The identifier of the section that this option belongs to"
type: string
# hidden: yes
sql: ${TABLE}.section_id ;;
}
dimension: template_id {
description: "The identifier of the rubric template this option belongs to"
type: string
# hidden: yes
sql: ${TABLE}.template_id ;;
}
dimension_group: row_updated {
description: "UTC time this row was last updated"
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.row_updated_at ;;
}
measure: count {
type: count
drill_fields: [detail*]
}
# ----- Sets of fields for drilling ------
set: detail {
fields: [
option_id,
templates.name,
templates.template_id,
sections.section_id,
questions.question_id,
question_scores.count
]
}
}