56b5d0e6-862f-4f64-b705-d1e409464444
1
Standard
False
Default
True
False
0
6
Letter
Portrait
No
True
True
ShowMessage
True
True
False
Default
false
false
1
1
True
False
False
0
vwExhibitor_Order
False
1323397424
1847353972
widget
0
0
11
True
Arial
8
|
1680564302
Order Pacing_All
text
1
0
Center
9
True
Arial
14
True
|
79363134
vwExhibitor_Order.Event Name
data
3
0
9
True
Arial
9
True
4
#EDE668
#545454
#FFFFFF
|
1942745149
text
4
0
True
Arial
8
4
#ede668
|
895681793
text
5
0
True
Arial
8
4
#ede668
|
114846182
=DateDiff('w',Date(Year({vwExhibitor_Order.Order Date}), Month({vwExhibitor_Order.Order Date}), Day({vwExhibitor_Order.Order Date})),Date(Year({vwExhibitor_Order.Event Start Date}), Month({vwExhibitor_Order.Event Start Date}), Day({vwExhibitor_Order.Event Start Date})))
formula
5
1
8
True
Arial
9
True
4
#68edbd
#545454
#ffffff
|
751476332
=[I10]
formula
5
9
True
Arial
8
|
1625060245
=[I11]
formula
5
10
True
Arial
8
|
1709598093
text
6
0
True
Arial
8
4
#ede668
|
2082996373
text
6
1
True
Arial
8
4
#68edbd
|
2061734632
text
7
0
True
Arial
8
4
#ede668
|
760287585
CoID
text
7
1
2
True
Arial
9
True
4
#68edbd
#545454
#ffffff
|
376212678
Company Name
text
7
3
2
True
Arial
9
True
#545454
#ffffff
|
1401382952
Item Type
text
7
5
2
True
Arial
9
True
#545454
#ffffff
|
1127446187
Order Amount
text
7
7
2
True
Arial
9
True
#545454
#ffffff
|
1176050065
text
8
0
True
Arial
8
4
#ede668
|
1466058876
vwExhibitor_Order.CoID
data
8
1
Right
2
True
Arial
10
4
#68edbd
#545454
|
451013926
vwExhibitor_Order.Company Name
data
8
3
2
True
Arial
10
#545454
|
196657208
vwExhibitor_Order.Item Type
data
8
5
2
True
Arial
10
#545454
|
1185144237
vwExhibitor_Order.Total Order Amount
data
8
7
Right
2
True
Arial
10
Number
True
True
#545454
|
2122742376
text
9
0
True
Arial
8
4
#ede668
|
90109569
Distinct Count:
text
9
1
True
Arial
8
4
#68edbd
|
204456528
=aggdistinctcount({vwExhibitor_Order.CoID})
formula
9
2
Center
True
Arial
9
#545454
#ffffff
|
369682493
Total:
text
9
7
True
Arial
8
|
1143390750
=aggsum({vwExhibitor_Order.Total Order Amount})
formula
9
8
Center
True
Arial
9
#545454
#ffffff
|
1333772550
=RunningSum({vwExhibitor_Order.Total Order Amount},{vwExhibitor_Order.Event Name})
formula
10
8
True
Arial
8
|
1620814362
text
11
0
True
Arial
8
4
#ede668
|
586092313
text
12
0
True
Arial
8
4
#ede668
|
572646577
Distinct Count:
text
12
1
True
Arial
8
|
1999035637
=aggdistinctcount({vwExhibitor_Order.CoID})
formula
12
2
Center
True
Arial
9
#545454
#ffffff
|
876045754
Total:
text
12
7
True
Arial
8
|
543171661
=aggsum({vwExhibitor_Order.Total Order Amount})
formula
12
8
Center
True
Arial
9
#545454
#ffffff
|
1014499085
Report Totals
text
14
1
8
True
Arial
8
True
|
550520344
Distinct Count:
text
15
1
True
Arial
8
|
1280906149
=aggdistinctcount({vwExhibitor_Order.CoID})
formula
15
2
Right
True
Arial
9
#545454
#FFFFFF
|
1522299913
Total:
text
15
7
True
Arial
8
|
1155471669
=aggsum({vwExhibitor_Order.Total Order Amount})
formula
15
8
Right
True
Arial
9
#545454
#FFFFFF
|
Report Header
300
Page Header
True
Header
vwExhibitor_Order.Event Name
True
Header
vwExhibitor_Order.Event Name
True
Header
=DateDiff('w',Date(Year({vwExhibitor_Order.Order Date}), Month({vwExhibitor_Order.Order Date}), Day({vwExhibitor_Order.Order Date})),Date(Year({vwExhibitor_Order.Event Start Date}), Month({vwExhibitor_Order.Event Start Date}), Day({vwExhibitor_Order.Event Start Date})))
True
Header
=DateDiff('w',Date(Year({vwExhibitor_Order.Order Date}), Month({vwExhibitor_Order.Order Date}), Day({vwExhibitor_Order.Order Date})),Date(Year({vwExhibitor_Order.Event Start Date}), Month({vwExhibitor_Order.Event Start Date}), Day({vwExhibitor_Order.Event Start Date})))
True
Header
=DateDiff('w',Date(Year({vwExhibitor_Order.Order Date}), Month({vwExhibitor_Order.Order Date}), Day({vwExhibitor_Order.Order Date})),Date(Year({vwExhibitor_Order.Event Start Date}), Month({vwExhibitor_Order.Event Start Date}), Day({vwExhibitor_Order.Event Start Date})))
True
Header
=DateDiff('w',Date(Year({vwExhibitor_Order.Order Date}), Month({vwExhibitor_Order.Order Date}), Day({vwExhibitor_Order.Order Date})),Date(Year({vwExhibitor_Order.Event Start Date}), Month({vwExhibitor_Order.Event Start Date}), Day({vwExhibitor_Order.Event Start Date})))
True
Detail
True
#F1F1F1
#ffffff
Footer
=DateDiff('w',Date(Year({vwExhibitor_Order.Order Date}), Month({vwExhibitor_Order.Order Date}), Day({vwExhibitor_Order.Order Date})),Date(Year({vwExhibitor_Order.Event Start Date}), Month({vwExhibitor_Order.Event Start Date}), Day({vwExhibitor_Order.Event Start Date})))
True
Footer
=DateDiff('w',Date(Year({vwExhibitor_Order.Order Date}), Month({vwExhibitor_Order.Order Date}), Day({vwExhibitor_Order.Order Date})),Date(Year({vwExhibitor_Order.Event Start Date}), Month({vwExhibitor_Order.Event Start Date}), Day({vwExhibitor_Order.Event Start Date})))
True
Footer
vwExhibitor_Order.Event Name
True
Footer
vwExhibitor_Order.Event Name
True
Report Footer
True
Report Footer
True
30
Report Footer
True
15
50
150
50
150
50
150
50
150
100
100
vwExhibitor_Order.Event Name
0
True
=DateDiff('w',Date(Year({vwExhibitor_Order.Order Date}), Month({vwExhibitor_Order.Order Date}), Day({vwExhibitor_Order.Order Date})),Date(Year({vwExhibitor_Order.Event Start Date}), Month({vwExhibitor_Order.Event Start Date}), Day({vwExhibitor_Order.Event Start Date})))
1
False
vwExhibitor_Order.Item Type
2
True
vwExhibitor_Order.Company Name
3
True
vwExhibitor_Order.Total Order Amount
4
True
vwExhibitor_Order.CoID
5
True
vwExhibitor_Order.IsAdjustedOrder
0
=
False
True
False
1433800882
0
vwExhibitor_Order.Event Name
1
oo
True
True
False
850177079
top
False
10
-1
1847353972
294
1009
True
Chart
Chart
1333772550,114846182,79363134,-1,-1
1847353972
line
False
False
Right
None
1
1
1
Default
0
True
-2
#947584,#A0CDCA,#D2555B,#FCB17A,#E8C7D8,#BCDB6D,#8FB5B1,#FBB9FF,#AEB27F,#7FC971
#ff0000,#0000ff
#ecdfbd,#20457c,#3b3a35,#fb6648,#5e3448
SortByDataLabels
Descending
-1
.
False
,
False
$
False
-1
False
False
False
-1
False
False
False
[]
Roboto
Legacy
{"dataLabelsCellId":114846182,"dataValuesCellId":1333772550,"seriesLabelsCellId":79363134,"bubbleSizesCellId":-1,"bubbleLabelsCellId":-1}
[{"fusionName":"labelDisplay","value":"AUTO"}]
[{"fusionName":"captionAlignment","value":"center"},{"fusionName":"captionOnTop","value":"1"},{"fusionName":"captionFont","value":"Roboto"},{"fusionName":"captionFontSize","value":"18"},{"fusionName":"captionFontColor","value":"#5a5a5a"},{"fusionName":"subCaptionFont","value":"Roboto"},{"fusionName":"subCaptionFontSize","value":"12"},{"fusionName":"subCaptionFontColor","value":"#5a5a5a"},{"fusionName":"baseFontSize","value":"11"},{"fusionName":"baseFontColor","value":"#888888"}]
[]
shortScale
[{"label":"Mean","value":null,"color":"#00ff00","lineStyle":0,"lineFunction":3},{"label":"UCL","value":"3","color":"#ff0000","lineStyle":1,"lineFunction":5},{"label":"LCL","value":"-3","color":"#ff0000","lineStyle":1,"lineFunction":6}]
False
8d54f674-3935-41e7-baa1-d5f6089f095b
Order.Item Type
vwExhibitor_Order.Item Type
MultiChoice
EqualTo
Ascending
False
b13f2ca7-7e47-4c95-a4f5-6d8740f9da12
Order.Item
vwExhibitor_Order.Item
MultiChoice
EqualTo
Ascending
False
0dbcc0bf-bc93-40f9-97f7-38c5c6c63735
Order.Sales Person Full Name
vwExhibitor_Order.Sales Person Full Name
SingleChoice
EqualTo
Ascending
False