-
Notifications
You must be signed in to change notification settings - Fork 6
/
historical_pipeline.sf.dashboard.lookml
128 lines (128 loc) · 3.49 KB
/
historical_pipeline.sf.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
- dashboard: historical_pipeline
title: Historical Pipeline
layout: newspaper
elements:
- title: Historical Pipeline Snapshot
name: Historical Pipeline Snapshot
model: salesforce_fivetran
explore: historical_snapshot
type: looker_area
fields:
- historical_snapshot.snapshot_date
- historical_snapshot.stage_name_funnel
- historical_snapshot.total_amount
pivots:
- historical_snapshot.stage_name_funnel
filters:
historical_snapshot.snapshot_date: 12 months
historical_snapshot.stage_name_funnel: "-Closed Won,-Closed Lost,-Unknown"
sorts:
- historical_snapshot.snapshot_date desc
- historical_snapshot.stage_name_funnel desc
- historical_snapshot.stage_name_funnel__sort_
limit: 500
column_limit: 50
query_timezone: America/Los_Angeles
stacking: normal
show_value_labels: false
label_density: 25
legend_position: center
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
y_axis_combined: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
x_axis_scale: auto
colors:
- "#7FCDAE"
- "#85D67C"
- "#CADF79"
- "#E7AF75"
- "#EB9474"
- "#EE7772"
show_null_points: true
point_style: none
interpolation: step
row: 0
col: 0
width: 12
height: 12
- title: Quarterly Pipeline Development Report - Q4
name: Quarterly Pipeline Development Report - Q4
model: salesforce_fivetran
explore: historical_snapshot
type: looker_area
fields:
- historical_snapshot.snapshot_date
- historical_snapshot.probability_tier
- historical_snapshot.total_amount
pivots:
- historical_snapshot.probability_tier
filters:
historical_snapshot.close_date: after 2 quarters ago
historical_snapshot.snapshot_date: before 0 minutes ago
historical_snapshot.stage_name_funnel: Closed Won,Negotiation/Review,Perception
Analysis,Proposal/Price Quote
sorts:
- historical_snapshot.snapshot_date
- historical_snapshot.snapshot_month desc
- historical_snapshot.close_month
- historical_snapshot.stage_name_funnel__sort_
- historical_snapshot.probability_tier
- historical_snapshot.probability_tier__sort_
limit: 500
column_limit: 50
query_timezone: America/Los_Angeles
stacking: normal
show_value_labels: false
label_density: 25
legend_position: center
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
y_axis_combined: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
x_axis_scale: auto
point_style: none
interpolation: linear
ordering: none
show_null_labels: false
reference_lines:
- reference_type: line
range_start: max
range_end: min
margin_top: deviation
margin_value: mean
margin_bottom: deviation
line_value: '7200000'
label: Goal ($1.2M)
color: purple
__FILE: salesforce_block/historical_pipeline.sf.dashboard.lookml
__LINE_NUM: 100
colors:
- black
- "#1FD110"
- "#95d925"
- "#d0ca0e"
- "#c77706"
- "#bf2006"
- lightgrey
- black
show_null_points: true
hidden_series:
- 20 - 39%
- 1 - 19%
row: 0
col: 12
width: 12
height: 12