/
invoice_lookup.dashboard.lookml
150 lines (138 loc) · 4.21 KB
/
invoice_lookup.dashboard.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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
- dashboard: invoice_lookup
title: Invoice Lookup
layout: grid
rows:
- elements: [add_a_unique_name_1462219740461, add_a_unique_name_1462219746929, add_a_unique_name_1462219744885]
height: 200
- elements: [add_a_unique_name_1462219749096, add_a_unique_name_1462219750792, add_a_unique_name_1462219752421, add_a_unique_name_1462219754125, add_a_unique_name_1462219755769]
height: 200
- elements: [add_a_unique_name_1462219742897]
height: 500
filters:
- name: invoice_id
title: "Invoice ID"
type: field_filter
explore: calendar
field: invoices.id
default_value: in^_80bEWMNEErTWfo #change the default filter value
elements:
- name: add_a_unique_name_1462219740461
title: Invoice Detail
type: looker_single_record
model: segment_stripe
explore: calendar
dimensions: [customers.email, invoices.total, invoices.amount_due, charges.currency,
invoices.paid, invoices.attempted, invoices.closed, invoices.attempt_count, invoices.ending_balance]
listen:
invoice_id: invoices.id
sorts: [customers.email, invoices.total]
limit: 500
column_limit: 50
show_view_names: false
- name: add_a_unique_name_1462219742897
title: Invoice Charges
type: table
model: segment_stripe
explore: calendar
dimensions: [charges.created_date, charges.received_date, charges.failure_code,
charges.currency, charges.paid, charges.days_until_received, charges.status, charges.refunded]
measures: [charges.total_gross_amount, charges.total_refunds, charges.total_failed_charges,
charges.total_net_amount]
listen:
invoice_id: invoices.id
sorts: [charges.created_date desc]
limit: 500
- name: add_a_unique_name_1462219744885
title: Total Net Charges
type: single_value
model: segment_stripe
explore: calendar
measures: [charges.total_net_amount]
listen:
invoice_id: invoices.id
sorts: [charges.total_net_amount desc]
limit: 500
font_size: small
value_format: ''
text_color: black
- name: add_a_unique_name_1462219746929
title: Total Gross Charges
type: single_value
model: segment_stripe
explore: calendar
measures: [charges.total_gross_amount]
listen:
invoice_id: invoices.id
sorts: [charges.total_gross_amount desc]
limit: 500
font_size: small
value_format: ''
text_color: black
- name: add_a_unique_name_1462219749096
title: Total Failed Charges Amount
type: single_value
model: segment_stripe
explore: calendar
measures: [charges.charge_count]
filters:
charges.status: failed
listen:
invoice_id: invoices.id
sorts: [charges.charge_count desc]
limit: 500
font_size: small
value_format: ''
text_color: black
- name: add_a_unique_name_1462219750792
title: Total Unpaid Invoices Amount
type: single_value
model: segment_stripe
explore: calendar
measures: [invoices.total_amount_due]
filters:
invoices.paid: 'No'
listen:
invoice_id: invoices.id
sorts: [invoices.total_amount_due desc]
limit: 500
font_size: small
value_format: ''
text_color: black
- name: add_a_unique_name_1462219752421
title: Average Days Until Payment Received
type: single_value
model: segment_stripe
explore: calendar
measures: [charges.avg_days_until_received]
listen:
invoice_id: invoices.id
sorts: [charges.outstanding_charge_time desc, charges.avg_days_until_received desc]
limit: 500
font_size: small
text_color: black
- name: add_a_unique_name_1462219754125
title: Total Charges
type: single_value
model: segment_stripe
explore: calendar
measures: [charges.charge_count]
listen:
invoice_id: invoices.id
sorts: [charges.charge_count desc]
limit: 500
font_size: small
value_format: ''
text_color: black
- name: add_a_unique_name_1462219755769
title: Total Failed Charges
type: single_value
model: segment_stripe
explore: calendar
measures: [charges.total_failed_charges]
listen:
invoice_id: invoices.id
sorts: [charges.total_failed_charges desc]
limit: 500
font_size: small
value_format: ''
text_color: black