0
OFAReporting
RowNum
System.Int64
state
System.String
CountName
System.String
Value
System.Int64
DateTime
System.DateTime
2.14583in
1in
1in
1in
0.25in
true
true
Textbox3
2pt
2pt
2pt
2pt
true
true
Yesterday
Textbox8
2pt
2pt
2pt
2pt
true
true
Total
Textbox10
2pt
2pt
2pt
2pt
true
true
Textbox36
2pt
2pt
2pt
2pt
0.25in
true
true
Contacts
Textbox15
2pt
2pt
2pt
2pt
true
true
=Max(iif((Fields!CountName.Value = "yesterdays_contacts") And (Fields!RowNum.Value = "1") And (Fields!state.Value = "US"), Fields!Value.Value, 0))
Textbox9
2pt
2pt
2pt
2pt
true
true
=Max(iif((Fields!CountName.Value = "all_contacts") And (Fields!RowNum.Value = "1") And (Fields!state.Value = "US"), Fields!Value.Value, 0))
Textbox9
2pt
2pt
2pt
2pt
=Fields!DateTime.Value
=Fields!DateTime.Value
=Max(Fields!Value.Value)
Output
Line
Primary
Primary
Black
0pt
False
Axis Title
False
False
0.5
NaN
NaN
NaN
False
Axis Title
False
False
0.5
NaN
Opposite
NaN
NaN
False
Axis Title
0.5
NaN
NaN
NaN
False
Axis Title
0.5
NaN
Opposite
NaN
NaN
BrightPastel
No Data Available
Sparkline
DataSet1
=Fields!state.Value
Equal
US
=Fields!CountName.Value
Equal
yesterdays_contacts
White
None
0.25in
true
true
"I'm In" Contacts
Textbox12
2pt
2pt
2pt
2pt
true
true
=Max(iif((Fields!CountName.Value = "im_in_contacts_yesterday") And (Fields!RowNum.Value = "1") And (Fields!state.Value = "US"), Fields!Value.Value, 0))
Textbox9
2pt
2pt
2pt
2pt
true
true
=Max(iif((Fields!CountName.Value = "im_in_contacts_total") And (Fields!RowNum.Value = "1") And (Fields!state.Value = "US"), Fields!Value.Value, 0))
Textbox9
2pt
2pt
2pt
2pt
=Fields!DateTime.Value
=Fields!DateTime.Value
=Max(Fields!Value.Value)
Output
Line
Primary
Primary
Black
0pt
False
Axis Title
False
False
0.5
NaN
NaN
NaN
False
Axis Title
False
False
0.5
NaN
Opposite
NaN
NaN
False
Axis Title
0.5
NaN
NaN
NaN
False
Axis Title
0.5
NaN
Opposite
NaN
NaN
BrightPastel
No Data Available
Sparkline
DataSet1
=Fields!state.Value
Equal
US
=Fields!CountName.Value
Equal
im_in_contacts_yesterday
White
None
0.25in
true
true
"I'm In" Pledges
Textbox18
2pt
2pt
2pt
2pt
true
true
=Max(iif((Fields!CountName.Value = "im_in_pledges_yesterday") And (Fields!RowNum.Value = "1") And (Fields!state.Value = "US"), Fields!Value.Value, 0))
Textbox9
2pt
2pt
2pt
2pt
true
true
=Max(iif((Fields!CountName.Value = "im_in_pledges_total") And (Fields!RowNum.Value = "1") And (Fields!state.Value = "US"), Fields!Value.Value, 0))
Textbox9
2pt
2pt
2pt
2pt
=Fields!DateTime.Value
=Fields!DateTime.Value
=Max(Fields!Value.Value)
Output
Line
Primary
Primary
Black
0pt
False
Axis Title
False
False
0.5
NaN
NaN
NaN
False
Axis Title
False
False
0.5
NaN
Opposite
NaN
NaN
False
Axis Title
0.5
NaN
NaN
NaN
False
Axis Title
0.5
NaN
Opposite
NaN
NaN
BrightPastel
No Data Available
Sparkline
DataSet1
=Fields!state.Value
Equal
US
=Fields!CountName.Value
Equal
im_in_pledges_yesterday
White
None
0.25in
true
true
1:1s
Textbox6
2pt
2pt
2pt
2pt
true
true
=max(iif(
(Fields!CountName.Value="yesterdays_oneonones")
AND (Fields!RowNum.Value="1")
AND (Fields!state.Value="US"),
Fields!Value.Value,
0)
)
Textbox9
2pt
2pt
2pt
2pt
true
true
=Max(iif((Fields!CountName.Value = "all_oneonones") And (Fields!RowNum.Value = "1") And (Fields!state.Value = "US"), Fields!Value.Value, 0))
Textbox9
2pt
2pt
2pt
2pt
=Fields!DateTime.Value
=Fields!DateTime.Value
=Max(Fields!Value.Value)
Output
Line
Primary
Primary
Black
0pt
False
Axis Title
False
False
0.5
NaN
NaN
NaN
False
Axis Title
False
False
0.5
NaN
Opposite
NaN
NaN
False
Axis Title
0.5
NaN
NaN
NaN
False
Axis Title
0.5
NaN
Opposite
NaN
NaN
BrightPastel
No Data Available
Sparkline
DataSet1
=Fields!state.Value
Equal
US
=Fields!CountName.Value
Equal
yesterdays_oneonones
White
None
0.25in
true
true
Summer Organizer Applicatns
Textbox28
2pt
2pt
2pt
2pt
true
true
Textbox29
2pt
2pt
2pt
2pt
true
true
=Max(iif((Fields!CountName.Value = "sos_applicants") And (Fields!RowNum.Value = "1") And (Fields!state.Value = "US"), Fields!Value.Value, 0))
Textbox9
2pt
2pt
2pt
2pt
true
true
Textbox41
2pt
2pt
2pt
2pt
0.25in
true
true
Summer Organizer Accepted
Textbox31
2pt
2pt
2pt
2pt
true
true
Textbox32
2pt
2pt
2pt
2pt
true
true
=Max(iif((Fields!CountName.Value = "sos_accepted") And (Fields!RowNum.Value = "1") And (Fields!state.Value = "US"), Fields!Value.Value, 0))
Textbox9
2pt
2pt
2pt
2pt
true
true
Textbox42
2pt
2pt
2pt
2pt
DataSet1
0.73833in
0.23833in
1.75in
5.14583in
2.48833in
6.5in
1in
1in
1in
1in
Inch
579a4ce1-efbd-4c71-bb03-bd665ebce330