forked from llooker/stripe_block
-
Notifications
You must be signed in to change notification settings - Fork 0
/
subscriptions.view.lookml
88 lines (70 loc) · 1.75 KB
/
subscriptions.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
- view: subscriptions
sql_table_name: stripe.subscriptions
fields:
- dimension: id
primary_key: true
type: string
sql: ${TABLE}.id
- dimension: cancel_at_period_end
type: yesno
sql: ${TABLE}.cancel_at_period_end
- dimension_group: canceled
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.canceled_at
- dimension_group: current_period_end
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.current_period_end
- dimension_group: current_period_start
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.current_period_start
- dimension: customer_id
type: string
# hidden: true
sql: ${TABLE}.customer_id
- dimension: discount_id
type: string
# hidden: true
sql: ${TABLE}.discount_id
- dimension: plan_id
type: string
# hidden: true
sql: ${TABLE}.plan_id
- dimension: quantity
type: number
sql: ${TABLE}.quantity
- dimension_group: received
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.received_at
- dimension_group: start
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.start
- dimension: status
type: string
sql: ${TABLE}.status
- dimension_group: trial_end
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.trial_end
- dimension_group: trial_start
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.trial_start
- measure: count
type: count
drill_fields: detail*
# ----- Sets of fields for drilling ------
sets:
detail:
- id
- customers.id
- discounts.id
- plans.id
- plans.name
- invoice_items.count
- invoice_lines.count
- invoices.count