-
Notifications
You must be signed in to change notification settings - Fork 4
/
conversation_parts.view.lkml
65 lines (53 loc) · 1.41 KB
/
conversation_parts.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
view: conversations_parts {
sql_table_name: public.cont_ic_conversations_parts;;
dimension: id {
primary_key: yes
description: "Unique identifier of conversation part"
type: string
sql: ${TABLE}.id ;;
}
dimension: assigned_to_id {
description: "Unique identifier of assignee"
type: string
sql: ${TABLE}.assigned_to_id ;;
}
dimension: author_id {
description: "Unique identifier of the author"
type: string
sql: ${TABLE}.author_id ;;
}
dimension: author_type {
type: string
sql: ${TABLE}.author_type ;;
}
dimension: part_type {
description: "Part type, i.e Comment, Close, Note, Assignment"
type: string
sql: ${TABLE}.part_type ;;
}
dimension: body {
description: "Message body"
type: string
sql: ${TABLE}.body ;;
}
dimension: conversation_id {
description: "Unique identifier of the related conversation"
type: string
sql: ${TABLE}.conversation_id ;;
}
dimension_group: updated {
description: "Upadate time"
type: time
timeframes: [time, date, week, month, raw]
sql: ${TABLE}.updated_at;;
}
measure: count {
type: count
drill_fields: [updated_month, count]
}
measure: percent_of_tickets{
description: "Calculates a cell’s portion of the column total. The percentage is being calculated against the total of the displayed rows"
type: percent_of_total
sql: ${count} ;;
}
}