{
"ReportVersion": "2021.3.2.0",
"ReportGuid": "af35f6974e9a4d1cb76c28526f90273e",
"ReportName": "Report",
"ReportAlias": "Report",
"ReportCreated": "/Date(1634298520000+0100)/",
"ReportChanged": "/Date(1634298520000+0100)/",
"EngineVersion": "EngineV2",
"ReportUnit": "Inches",
"Script": "using System;\r\nusing System.Drawing;\r\nusing System.Windows.Forms;\r\nusing System.Data;\r\nusing Stimulsoft.Controls;\r\nusing Stimulsoft.Base.Drawing;\r\nusing Stimulsoft.Report;\r\nusing Stimulsoft.Report.Dialogs;\r\nusing Stimulsoft.Report.Components;\r\n\r\nnamespace Reports\r\n{\r\n public class Report : Stimulsoft.Report.StiReport\r\n {\r\n public Report() {\r\n this.InitializeComponent();\r\n }\r\n\r\n #region StiReport Designer generated code - do not modify\r\n\t\t#endregion StiReport Designer generated code - do not modify\r\n }\r\n}\r\n",
"RefreshTime": 300,
"ReferencedAssemblies": {
"0": "System.Dll",
"1": "System.Drawing.Dll",
"2": "System.Windows.Forms.Dll",
"3": "System.Data.Dll",
"4": "System.Xml.Dll",
"5": "Stimulsoft.Controls.Dll",
"6": "Stimulsoft.Base.Dll",
"7": "Stimulsoft.Report.Dll"
},
"Dictionary": {
"Variables": {
"0": {
"Name": "Status",
"DialogInfo": {
"DateTimeType": "DateAndTime",
"SortDirection": "None",
"CheckedColumn": "null;"
},
"Alias": "Status",
"Type": "System.String"
}
},
"DataSources": {
"0": {
"Ident": "StiSqlSource",
"Name": "AllValues",
"Alias": "AllValues",
"Key": "0f5ef38734684abebd2a0e213ba8ca07",
"Columns": {
"0": {
"Name": "Type",
"Index": -1,
"NameInSource": "Type",
"Alias": "Type",
"Type": "System.String"
},
"1": {
"Name": "Customer Name",
"Index": -1,
"NameInSource": "Customer Name",
"Alias": "Customer Name",
"Type": "System.String"
},
"2": {
"Name": "Assigned To",
"Index": -1,
"NameInSource": "Assigned To",
"Alias": "Assigned To",
"Type": "System.String"
},
"3": {
"Name": "Sender",
"Index": -1,
"NameInSource": "Sender",
"Alias": "Sender",
"Type": "System.String"
},
"4": {
"Name": "TenantId",
"Index": -1,
"NameInSource": "TenantId",
"Alias": "TenantId",
"Type": "System.Guid"
},
"5": {
"Name": "Total Value",
"Index": -1,
"NameInSource": "Total Value",
"Alias": "Total Value",
"Type": "System.Decimal"
},
"6": {
"Name": "Tran Status",
"Index": -1,
"NameInSource": "Tran Status",
"Alias": "Tran Status",
"Type": "System.String"
},
"7": {
"Name": "Doc Date",
"Index": -1,
"NameInSource": "Doc Date",
"Alias": "Doc Date",
"Type": "System.DateTime"
},
"8": {
"Name": "Processed Date",
"Index": -1,
"NameInSource": "Processed Date",
"Alias": "Processed Date",
"Type": "System.DateTime"
}
},
"NameInSource": "eTrading",
"SqlCommand": "select 'Transaction' as 'Type', Datastore.CustomerDetail.Description as 'Customer Name', NULL as 'Assigned To', Sender, Reports.transactionheader.TenantId, TotalInvoice as 'Total Value', NULL as 'Tran Status', Reports.TransactionHeader.TransactionDate as 'Doc Date', Reports.TransactionHeader.ProcessedDate as 'Processed Date'\nfrom Reports.TransactionHeader\ninner join Datastore.CustomerDetail on CustomerId = Datastore.CustomerDetail.Id\nwhere Sender is not null\nand FeedData = 0\n\nunion all\n\nselect 'Suspense' as 'Type', Datastore.CustomerDetail.Description as 'Customer Name', Reports.TransactionGroup.Name as 'Assigned To', NULL as 'Sender', Reports.TransactionHeader.TenantId, NULL as 'TotalValue', EnumTransactionStatus.Description as 'Tran Status', Reports.TransactionHeader.TransactionDate, Reports.TransactionHeader.ProcessedDate\nfrom Reports.TransactionHeader\ninner join Datastore.CustomerDetail on Datastore.CustomerDetail.Id = Reports.TransactionHeader.CustomerId\ninner join Reports.EnumTransactionStatus on Reports.TransactionHeader.TransactionStatus = Reports.EnumTransactionStatus.Value\ninner join Reports.TransactionGroup on TransactionGroup.Id = TransactionHeader.AssignedTransactionGroupId\nwhere TransactionStatus in (3, 5, 6, 7, 8, 9, 10, 11,12, 13, 14, 15, 20, 21)\nand FeedData = 0\norder by 1, 2, 3"
},
"1": {
"Ident": "StiSqlSource",
"Name": "MonthTotals",
"Alias": "MonthTotals",
"Key": "0b57620e5d1747548f61dca5db93c2e1",
"Columns": {
"0": {
"Name": "Month",
"Index": -1,
"NameInSource": "Month",
"Alias": "Month",
"Type": "System.String"
},
"1": {
"Name": "# Customers Live",
"Index": -1,
"NameInSource": "# Customers Live",
"Alias": "# Customers Live",
"Type": "System.Int32"
},
"2": {
"Name": "Total # of Senders",
"Index": -1,
"NameInSource": "Total # of Senders",
"Alias": "Total # of Senders",
"Type": "System.Int32"
},
"3": {
"Name": "Total # of Transactions",
"Index": -1,
"NameInSource": "Total # of Transactions",
"Alias": "Total # of Transactions",
"Type": "System.Int32"
},
"4": {
"Name": "YearMonthNum",
"Index": -1,
"NameInSource": "YearMonthNum",
"Alias": "YearMonthNum",
"Type": "System.String"
}
},
"NameInSource": "eTrading",
"SqlCommand": "select left(DateName( month , DateAdd( month , b.[Month 1Digit] , 0 ) - 1 ), 3) as 'Month',\ncount(*) as '# Customers Live', sum([# of Senders]) as 'Total # of Senders', sum([# of Transactions]) as 'Total # of Transactions', concat(b.Year,'-', b.Month) as 'YearMonthNum' from (\nselect Customer, count(*) as '# of Senders', sum([# of Transactions]) as '# of Transactions', TenantId, a.Year, a.Month, a.[Month 1Digit] from (\nselect CustomerDetail.Description as Customer, Sender, count(*) as '# of Transactions', Reports.transactionheader.TenantId, FORMAT(Reports.TransactionHeader.ProcessedDate,'MM') as 'Month', DATEPART(MONTH, Reports.TransactionHeader.ProcessedDate) as 'Month 1Digit', RIGHT(DATEPART(YEAR, Reports.TransactionHeader.ProcessedDate),2) as 'Year'\nfrom Reports.TransactionHeader\ninner join Datastore.CustomerDetail on CustomerId = Datastore.CustomerDetail.Id\nwhere Sender is not null\nand Reports.TransactionHeader.TenantId = '5A3CF9B5-3507-49DA-92C2-98CCFC46DF12'\nand FeedData = 0\ngroup by CustomerDetail.Description, Sender, Reports.transactionheader.TenantId, FORMAT(Reports.TransactionHeader.ProcessedDate,'MM'), DATEPART(MONTH, Reports.TransactionHeader.ProcessedDate), DATEPART(YEAR, Reports.TransactionHeader.ProcessedDate)) a\ngroup by Customer, TenantId, a.Year, a.Month, a.[Month 1Digit]) b\ngroup by TenantId, b.Month, b.Year, b.[Month 1Digit]\norder by 1, 5"
},
"2": {
"Ident": "StiSqlSource",
"Name": "Test",
"Alias": "Test",
"Key": "164bb30efdd6419191652ea56f4b5da3",
"Columns": {
"0": {
"Name": "Type",
"Index": -1,
"NameInSource": "Type",
"Alias": "Type",
"Type": "System.String"
},
"1": {
"Name": "Customer Name",
"Index": -1,
"NameInSource": "Customer Name",
"Alias": "Customer Name",
"Type": "System.String"
},
"2": {
"Name": "Assigned To",
"Index": -1,
"NameInSource": "Assigned To",
"Alias": "Assigned To",
"Type": "System.String"
},
"3": {
"Name": "Sender",
"Index": -1,
"NameInSource": "Sender",
"Alias": "Sender",
"Type": "System.String"
},
"4": {
"Name": "TenantId",
"Index": -1,
"NameInSource": "TenantId",
"Alias": "TenantId",
"Type": "System.Guid"
},
"5": {
"Name": "Total Value",
"Index": -1,
"NameInSource": "Total Value",
"Alias": "Total Value",
"Type": "System.Decimal"
},
"6": {
"Name": "Tran Status",
"Index": -1,
"NameInSource": "Tran Status",
"Alias": "Tran Status",
"Type": "System.String"
},
"7": {
"Name": "Tran Date",
"Index": -1,
"NameInSource": "Tran Date",
"Alias": "Tran Date",
"Type": "System.DateTime"
},
"8": {
"Name": "Processed Date",
"Index": -1,
"NameInSource": "Processed Date",
"Alias": "Processed Date",
"Type": "System.DateTime"
},
"9": {
"Name": "YearMonthNum",
"Index": -1,
"NameInSource": "YearMonthNum",
"Alias": "YearMonthNum",
"Type": "System.String"
}
},
"NameInSource": "eTrading",
"SqlCommand": "Select a.Type, a.[Customer Name], a.[Assigned To], a.Sender, a.TenantId, a.[Total Value], a.[Tran Status], a.[Tran Date],\na.[Processed Date], concat(a.Year,'-', a.Month) as 'YearMonthNum' from (\n\nselect 'Transaction' as 'Type', CustomerDetail.Description as 'Customer Name', NULL as 'Assigned To', Sender, Datastore.transactionheader.TenantId, TotalInvoice as 'Total Value', NULL as 'Tran Status', Datastore.TransactionHeader.TransactionDate as 'Tran Date', Datastore.TransactionHeader.ProcessedDate as 'Processed Date',\n FORMAT(Datastore.TransactionHeader.ProcessedDate,'MM') as 'Month', DATEPART(MONTH, Datastore.TransactionHeader.ProcessedDate) as 'Month 1Digit', RIGHT(DATEPART(YEAR, Datastore.TransactionHeader.ProcessedDate),2) as 'Year'\nfrom Datastore.TransactionHeader\ninner join Datastore.CustomerDetail on CustomerId = Datastore.CustomerDetail.Id\nwhere Sender is not null\nand FeedData = 0\n\nunion all\n\nselect 'Suspense' as 'Type', Datastore.CustomerDetail.Description as 'Customer Name', case when Datastore.TransactionGroup.Name = 'OpenECX Admin' then 'OpenECX Admin' else Datastore.CustomerDetail.Description end as 'Assigned To', NULL as 'Sender', datastore.TransactionHeader.TenantId, TotalInvoice as 'TotalValue', EnumTransactionStatus.Description as 'Tran Status', Datastore.TransactionHeader.TransactionDate, Datastore.TransactionHeader.ProcessedDate,\n FORMAT(Datastore.TransactionHeader.ProcessedDate,'MM') as 'Month', DATEPART(MONTH, Datastore.TransactionHeader.ProcessedDate) as 'Month 1Digit', RIGHT(DATEPART(YEAR, Datastore.TransactionHeader.ProcessedDate),2) as 'Year'\nfrom Datastore.TransactionHeader\ninner join Datastore.CustomerDetail on Datastore.CustomerDetail.Id = Datastore.TransactionHeader.CustomerId\ninner join Datastore.EnumTransactionStatus on Datastore.TransactionHeader.TransactionStatus = Datastore.EnumTransactionStatus.Value\ninner join Datastore.TransactionGroup on TransactionGroup.Id = TransactionHeader.AssignedTransactionGroupId\nwhere TransactionStatus in (3, 5, 6, 7, 8, 9, 10, 11,12, 13, 14, 15, 20, 21)\nand FeedData = 0\n) a\norder by 1, 2, 3"
},
"3": {
"Ident": "StiSqlSource",
"Name": "TenantTotals",
"Alias": "TenantTotals",
"Key": "50e440c5354b4d4db65caec879660b70",
"Columns": {
"0": {
"Name": "# Customers Live",
"Index": -1,
"NameInSource": "# Customers Live",
"Alias": "# Customers Live",
"Type": "System.Int32"
},
"1": {
"Name": "Total # of Senders",
"Index": -1,
"NameInSource": "Total # of Senders",
"Alias": "Total # of Senders",
"Type": "System.Int32"
},
"2": {
"Name": "Total # of Transactions",
"Index": -1,
"NameInSource": "Total # of Transactions",
"Alias": "Total # of Transactions",
"Type": "System.Int32"
},
"3": {
"Name": "TotalValue",
"Index": -1,
"NameInSource": "TotalValue",
"Alias": "TotalValue",
"Type": "System.Decimal"
}
},
"NameInSource": "eTrading",
"SqlCommand": "select count(*) as '# Customers Live', sum([# of Senders]) as 'Total # of Senders', sum([# of Transactions]) as 'Total # of Transactions', sum(TotalValue) as 'TotalValue' from (\nselect Customer, count(*) as '# of Senders', sum([# of Transactions]) as '# of Transactions', sum(TotalValue) as 'TotalValue', TenantId from (\nselect CustomerDetail.Description as Customer, Sender, count(*) as '# of Transactions', sum(TotalInvoice) as 'TotalValue', Reports.transactionheader.TenantId\nfrom Reports.TransactionHeader\ninner join Datastore.CustomerDetail on CustomerId = Datastore.CustomerDetail.Id\nwhere Sender is not null\nand Reports.TransactionHeader.TenantId = '5A3CF9B5-3507-49DA-92C2-98CCFC46DF12'\nand FeedData = 0\ngroup by CustomerDetail.Description, Sender, Reports.transactionheader.TenantId) a\ngroup by Customer, TenantId) b\ngroup by TenantId"
},
"4": {
"Ident": "StiSqlSource",
"Name": "CurrentStatus",
"Alias": "CurrentStatus",
"Key": "2ce0906c87ed46609d1b0504ab8899c0",
"Columns": {
"0": {
"Name": "Last Transaction",
"Index": -1,
"NameInSource": "Last Transaction",
"Alias": "Last Transaction",
"Type": "System.String"
},
"1": {
"Name": "Hours Since Last Transaction",
"Index": -1,
"NameInSource": "Hours Since Last Transaction",
"Alias": "Hours Since Last Transaction",
"Type": "System.Decimal"
},
"2": {
"Name": "Transaction Hour",
"Index": -1,
"NameInSource": "Transaction Hour",
"Alias": "Transaction Hour",
"Type": "System.String"
},
"3": {
"Name": "Current Day Name",
"Index": -1,
"NameInSource": "Current Day Name",
"Alias": "Current Day Name",
"Type": "System.String"
},
"4": {
"Name": "Current Hour",
"Index": -1,
"NameInSource": "Current Hour",
"Alias": "Current Hour",
"Type": "System.Int32"
},
"5": {
"Name": "Current Status",
"Index": -1,
"NameInSource": "Current Status",
"Alias": "Current Status",
"Type": "System.Decimal"
}
},
"NameInSource": "eTrading",
"SqlCommand": "select *, \ncase when a.[Current Day Name] = 'Saturday' then 25 \nwhen a.[Current Day Name] = 'Sunday' then 25 \nelse \n\ncase when a.[Current Hour] between '09' and '17' then \n\ncase when a.[Hours Since Last Transaction] between 0.5 and 1 then 62.5\nwhen a.[Hours Since Last Transaction] > 1 then 87.5\nelse 25\nend \n\nelse 25 \nend \n\nend \nas 'Current Status' from (\nselect top 1 left(Datastore.transactionheader.ProcessedDate,16) as 'Last Transaction', DATEDIFF(SECOND, Datastore.transactionheader.ProcessedDate, DATEADD(hh, 0, getdate())) / 3600.0 as 'Hours Since Last Transaction', left(cast(Datastore.transactionheader.ProcessedDate as time),2) as 'Transaction Hour', DATENAME(dw,GETDATE()) 'Current Day Name', left(cast(getdate() as time),2) as 'Current Hour'\nfrom Datastore.TransactionHeader\nwhere Sender is not null\nand datastore.transactionheader.TenantId = '5A3CF9B5-3507-49DA-92C2-98CCFC46DF12'\nand FeedData = 0\norder by 1 desc) a\n"
}
},
"Databases": {
"0": {
"Ident": "StiSqlDatabase",
"Name": "eTrading",
"Alias": "eTrading",
"ConnectionStringEncrypted": "1TDR6ecDWfXDGOCA6pilbsJu4evIXbsZ4GHQ9MtsImbH9lejyAoxhUUYqdjpWLUf1WzNwktUcp3/Yait6UHje9RczeNpUbuE42H5bORcbWqA0mXC5whDnWhNgPDkXPLn3FbZz+8Ik4lpE9GEyQQkD93IlQBPaFmd5wr5+MsEYn7geFcCTkzTyPhLqPRiXGGnzcj7y2ldw4FqGb2EZFzyP9Xy2QJOXdPN8U7ozE0AImKLeNWjRlbT8MYT7YVjfXVCgOj7K+dce53DTaRY6XixY8jWU4joUVuFaQqh7OkEpDvFbvnLT1a7BeJT5WxlGLUP3mxpo00U+/jKeoTw92z3k5JUZYjuXXHNRljVyWRJrLPTwFPr431Z7WxP/cxjxOl/kNLZicldQ5niCbkYRUQgG9X2Z6NOSnvd7EHx3MsJ93vVbH+jxUx78eFf4MT7Gecn02j/60hUW4jibuHJSXj2e9Z42yBNXOuYa120iWpc4WqLyPcrSFRDfWtLqNxzbOMb2Q=="
}
}
},
"Pages": {
"0": {
"Ident": "StiDashboard",
"Name": "Main",
"Guid": "aa201bb171b749178945549c0eabb7c1",
"Brush": "solid:",
"Components": {
"0": {
"Ident": "StiIndicatorElement",
"Name": "Indicator2",
"Guid": "84e94de079d2440e8c2e33c4abaebb62",
"ClientRectangle": "860,60,170,60",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "5b2b40fe6f1e4f31a38ecc97b98ac0ff",
"Path": "Test.Type",
"Value": "Suspense"
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits"
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "462fdcad2da6436a894c49f747a8452f",
"Expression": "Count(Test.Type)",
"Label": "Type"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"GlyphColor": "Yellow",
"Font": ";13;Bold;",
"Style": "SlateGray"
},
"1": {
"Ident": "StiTextElement",
"Name": "Text9",
"Guid": "0cc7c890d7c84a2fac9696fc25aa5c25",
"ClientRectangle": "0,340,1200,30",
"Border": "All;128,128,128;;;",
"Text": "Suspense",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"2": {
"Ident": "StiChartElement",
"Name": "Chart2",
"Guid": "3dd34ea5a0ec4c0c85f3b94db2c0a0c8",
"ClientRectangle": "0,400,280,200",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "84f09b96b90a4d5cbcc0501ddb8ecb75",
"Path": "Test.Type",
"Value": "Suspense"
}
},
"Values": {
"0": {
"Ident": "ValueChartMeter",
"Key": "b5b2169a943b40969f819bcd6263fc2c",
"Expression": "Count(Test.AssignedTo)",
"Label": "Assigned To",
"SeriesType": "Pie"
}
},
"Arguments": {
"0": {
"Ident": "ArgumentChartMeter",
"Key": "a5d694e8c1c549f9b8b6fd606481c291",
"Expression": "Test.AssignedTo",
"Label": "Assigned To"
}
},
"DashboardInteraction": {
"Ident": "Chart",
"OnHover": "ShowToolTip",
"OnClick": "ShowDashboard",
"HyperlinkDestination": "NewTab",
"DrillDownPageKey": "50a4799f4804486b9ea08c7fa99a8b04",
"DrillDownParameters": {
"0": {
"Name": "AssignedTo",
"Expression": "{Value}"
}
}
},
"Title": {
"Text": "Chart",
"Visible": false
},
"ArgumentFormat": {
"Ident": "StiGeneralFormatService"
},
"ValueFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits, Abbreviation"
},
"Area": {
"GridLinesHor": {
"Color": "Transparent",
"Visible": true
},
"GridLinesVert": {
"Color": "Transparent"
},
"InterlacingHor": {
"Color": "Transparent"
},
"InterlacingVert": {
"Color": "Transparent"
}
},
"Labels": {
"Position": "Center"
}
},
"3": {
"Ident": "StiChartElement",
"Name": "Chart3",
"Guid": "f3a32aad5cf94b99b7f19480981f0e8d",
"ClientRectangle": "280,400,920,200",
"Border": "All;128,128,128;;;",
"UserViewStates": {
"0": {
"Key": "5635400623094e9ba229f78085fab9a9",
"Name": "View 1",
"State": "H4sIAAAAAAAACnWPPQvCMBCGd8H/UDIpiKiNaeoqDqJOFve75ooFiZKkoEj/u43FWBWn+3ifg+fu/V4UsQOcKrJsEd392Cwm776Z1oq0azYttzyCcTtyZNgoIBu6eSARKAjjoshjxQFRxpNUCOB5igJBzDoXq+vFkLXlWfvD5bnSbpCRdePMgN47cJUddvAtIJ086eOozVmb1r7UT5TtyZQfnwT3NvmVf6lz4FOcc5knkHKSM4nIE1SgpjkoJVXgP8W/lAP117exrR/its3qdgEAAFpJUA=="
}
},
"Values": {
"0": {
"Ident": "ValueChartMeter",
"Key": "76b6eb3ffc3d4abb830966a4c9b6ba62",
"Expression": "Count(Test.TranStatus)",
"Label": "Tran Status"
}
},
"DashboardInteraction": {
"Ident": "Chart",
"OnHover": "ShowToolTip",
"OnClick": "ShowDashboard",
"HyperlinkDestination": "NewTab",
"DrillDownPageKey": "56363fe1530b4bcab137a5dc5888e7a1",
"DrillDownParameters": {
"0": {
"Name": "Status",
"Expression": "{Value}"
}
}
},
"Title": {
"Text": "Chart",
"Visible": false
},
"Series": {
"Ident": "SeriesChartMeter",
"Key": "4a41b548c7a94e828bb47bdad1cadd8d",
"Expression": "Test.TranStatus",
"Label": "Tran Status"
},
"ArgumentFormat": {
"Ident": "StiGeneralFormatService"
},
"ValueFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits, Abbreviation"
},
"YAxis": {
"Title": {
"Visible": false
}
},
"Legend": {
"HorAlignment": "Center",
"Visibility": "Always"
},
"Area": {
"GridLinesHor": {
"Color": "Transparent",
"Visible": true
},
"GridLinesVert": {
"Color": "Transparent"
},
"InterlacingHor": {
"Color": "Transparent"
},
"InterlacingVert": {
"Color": "Transparent"
}
},
"Labels": {
"Position": "OutsideEnd",
"Style": "Value"
},
"SelectedViewStateKey": "5635400623094e9ba229f78085fab9a9"
},
"4": {
"Ident": "StiTextElement",
"Name": "Text4",
"Guid": "059464f3a31a405fbb107c450f81066a",
"ClientRectangle": "0,130,1200,30",
"Border": "All;128,128,128;;;",
"Text": "Month Totals",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"5": {
"Ident": "StiChartElement",
"Name": "Chart1",
"Guid": "199c133156e04057a18e39a7b54ad4b5",
"ClientRectangle": "0,160,1200,180",
"Border": "All;128,128,128;;;",
"UserSorts": {
"0": {
"Key": "81cd58ec16f641e88e681163f1fee9d9"
}
},
"DataFilters": {
"0": {
"Key": "08bfacf7794445d3b1dc565717a236ed",
"Path": "Test.Type",
"Value": "Transaction"
}
},
"Values": {
"0": {
"Ident": "ValueChartMeter",
"Key": "73a9f92bda984f3486487502d35a02f8",
"Expression": "Count(Test.Type)",
"Label": "Total # Transactions",
"SeriesType": "Spline"
},
"1": {
"Ident": "ValueChartMeter",
"Key": "b9483356aec94a9d90c059a2987e85b0",
"Expression": "DistinctCount(Test.Sender)",
"Label": "Total # Senders",
"SeriesType": "Spline",
"YAxis": "RightYAxis",
"LineStyle": "Dash"
}
},
"Arguments": {
"0": {
"Ident": "ArgumentChartMeter",
"Key": "89e915f9d8ce42e3a65932fb30c27346",
"Expression": "Test.YearMonthNum",
"Label": "YearMonthNum"
}
},
"DashboardInteraction": {
"Ident": "Chart",
"OnHover": "ShowToolTip",
"OnClick": "ApplyFilter",
"HyperlinkDestination": "NewTab"
},
"Title": {
"Text": "Chart",
"Visible": false
},
"ArgumentFormat": {
"Ident": "StiGeneralFormatService"
},
"ValueFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits"
},
"XAxis": {
"Title": {
"Visible": false
}
},
"YAxis": {
"Labels": {
"Placement": "OneLine"
},
"Title": {
"Visible": false
}
},
"YRightAxis": {
"Title": {
"Visible": false
},
"Visible": true
},
"Legend": {
"HorAlignment": "Center"
},
"Area": {
"GridLinesHor": {
"Color": "Transparent",
"Visible": true
},
"GridLinesVert": {
"Color": "Transparent"
},
"InterlacingHor": {
"Color": "Transparent"
},
"InterlacingVert": {
"Color": "Transparent"
}
},
"Labels": {
"Font": ";11;Bold;",
"Position": "OutsideEnd",
"Style": "Value"
}
},
"6": {
"Ident": "StiDatePickerElement",
"Name": "DatePicker1",
"Guid": "fd19a20c732142559a5819d9e7f22685",
"ClientRectangle": "40,70,140,40",
"Border": "All;128,128,128;;;",
"SelectionMode": "AutoRange",
"ValueMeter": {
"Ident": "ValueDatePickerMeter",
"Key": "ae7351d84dfc4b709dfe4e37f39c9a45",
"Expression": "Test.ProcessedDate",
"Label": "Processed Date"
},
"TextFormat": {
"Ident": "StiDateFormatService"
}
},
"7": {
"Ident": "StiTextElement",
"Name": "Text2",
"Guid": "c49a6facc05e4140846ea3f8eb5176bf",
"ClientRectangle": "40,40,140,30",
"Border": "All;128,128,128;;;",
"Text": "Processed Date",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"8": {
"Ident": "StiTextElement",
"Name": "Text5",
"Guid": "a51af40d2eda40c99f29c8028c6a5e1e",
"ClientRectangle": "180,40,140,30",
"Border": "All;128,128,128;;;",
"Text": "Transaction Date",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"9": {
"Ident": "StiDatePickerElement",
"Name": "DatePicker2",
"Guid": "fea77f09f80b47ef935bc3d389b801ff",
"ClientRectangle": "180,70,140,40",
"Border": "All;128,128,128;;;",
"SelectionMode": "AutoRange",
"ValueMeter": {
"Ident": "ValueDatePickerMeter",
"Key": "c91a104af2eb4c5d8059af7d452ab97a",
"Expression": "Test.TranDate",
"Label": "Tran Date"
},
"TextFormat": {
"Ident": "StiDateFormatService"
}
},
"10": {
"Ident": "StiTextElement",
"Name": "Text6",
"Guid": "b4c9f8533d5844fb9f056f5ac362f1d1",
"ClientRectangle": "350,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "# Transactions",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"11": {
"Ident": "StiIndicatorElement",
"Name": "Indicator1",
"Guid": "e2ccfeda73ce4d639999e0eff594f221",
"ClientRectangle": "350,60,170,60",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "e9aca4e5a066495a94752574362533ce",
"Path": "Test.Type",
"Value": "Transaction"
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits"
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "21a0cdf89a42482ca644526a6cfd0802",
"Expression": "Count(Test.Type)",
"Label": "Type"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"GlyphColor": "0,176,240",
"Font": ";16;Bold;",
"Style": "SlateGray",
"Icon": "LineChart"
},
"12": {
"Ident": "StiTextElement",
"Name": "Text8",
"Guid": "f1dc553f970644afb5527a5f3add04fb",
"ClientRectangle": "520,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "# Senders",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"13": {
"Ident": "StiIndicatorElement",
"Name": "Indicator3",
"Guid": "de430ea67cb44b51aa7b51afd63e9584",
"ClientRectangle": "520,60,170,60",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "f8a0bb6f3250413a8e701f61d89ad345",
"Path": "Test.Type",
"Value": "Transaction"
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits"
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "32133ea4a9444faaaf28e4d737340e06",
"Expression": "DistinctCount(Test.Sender)",
"Label": "Sender"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"GlyphColor": "Red",
"Font": ";16;Bold;",
"Style": "SlateGray",
"Icon": "Envelope"
},
"14": {
"Ident": "StiTextElement",
"Name": "Text1",
"Guid": "fd0f31fc1d994b39a188682f6d691227",
"ClientRectangle": "690,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "£ Processed",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"15": {
"Ident": "StiIndicatorElement",
"Name": "Indicator4",
"Guid": "3316d37fce474e63bb316e5612a079bd",
"ClientRectangle": "690,60,170,60",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "93050b381cd747bdabc5301e79ba791e",
"Path": "Test.Type",
"Value": "Transaction"
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiCurrencyFormatService",
"NegativePattern": 0,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits",
"PositivePattern": 0
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "757cd1ecc0444ebcadf2159f4a9ee6ff",
"Expression": "Sum(Test.TotalValue)",
"Label": "Total Value"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"Font": ";16;Bold;",
"Style": "SlateGray",
"Icon": "Gbp"
},
"16": {
"Ident": "StiTextElement",
"Name": "Text3",
"Guid": "b939e73a8f92457ab7b466606d8eb365",
"ClientRectangle": "350,0,850,30",
"Border": "All;128,128,128;;;",
"Text": "Totals",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"17": {
"Ident": "StiTextElement",
"Name": "Text7",
"Guid": "dcfc80a5b6994d84824738a25b66d82b",
"ClientRectangle": "40,10,280,30",
"Border": "All;128,128,128;;;",
"Text": "Filters",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"18": {
"Ident": "StiTextElement",
"Name": "Text10",
"Guid": "5889b04ea32a4024a7fe56db263e1623",
"ClientRectangle": "860,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "# Suspense",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"19": {
"Ident": "StiTextElement",
"Name": "Text11",
"Guid": "940c5568d9594e57b4700a79da08d328",
"ClientRectangle": "0,370,280,30",
"Border": "All;128,128,128;;;",
"Text": "Assigned To",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"20": {
"Ident": "StiTextElement",
"Name": "Text12",
"Guid": "20319ec67dda4c26a41ebcea1028c606",
"ClientRectangle": "280,370,920,30",
"Border": "All;128,128,128;;;",
"Text": "Action Type Breakdown",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"21": {
"Ident": "StiIndicatorElement",
"Name": "Indicator5",
"Guid": "8b746e37586843489aba1414d595c640",
"ClientRectangle": "1030,60,170,60",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "a4c316d260764c3c9bd43a824980ad28",
"Path": "Test.Type",
"Value": "Suspense"
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiCurrencyFormatService",
"NegativePattern": 0,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits",
"PositivePattern": 0
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "a726afd035e841fb90e1dda5d3eccace",
"Expression": "Sum(Test.TotalValue)",
"Label": "Total Value"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"GlyphColor": "160,48,200",
"Font": ";16;Bold;",
"Style": "SlateGray",
"Icon": "Gbp"
},
"22": {
"Ident": "StiTextElement",
"Name": "Text13",
"Guid": "32a7b467e78d4da5b8d4dc7585056511",
"ClientRectangle": "1030,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "£ Suspense",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
}
},
"Border": ";;2;;;;;solid:Black"
},
"1": {
"Ident": "StiDashboard",
"Name": "Dashboard1",
"Guid": "56363fe1530b4bcab137a5dc5888e7a1",
"Brush": "solid:",
"Components": {
"0": {
"Ident": "StiIndicatorElement",
"Name": "Indicator7",
"Guid": "ae6e1d08e221445aaba0304b3acfeb78",
"ClientRectangle": "180,180,300,120",
"Border": ";;;;",
"DataFilters": {
"0": {
"Key": "0b68270ab9fc453ea3865c7773da3bb5",
"Path": "Test.TranStatus",
"Value": "this[\"Status\"]",
"IsExpression": true
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "bed8570597a549a0a5b2b5a53e6489f5",
"Expression": "Count(Test.TranStatus)",
"Label": "Tran Status"
},
"Title": {
"Text": "Indicator"
},
"Font": ";13;;"
}
},
"Border": ";;2;;;;;solid:Black"
},
"2": {
"Ident": "StiDashboard",
"Name": "Action_Type_Breakdown_Detail",
"Guid": "69b9f52c6bd34d13a058638b6de709ed",
"Brush": "solid:",
"Components": {
"0": {
"Ident": "StiIndicatorElement",
"Name": "Indicator6",
"Guid": "84e94de079d2440e8c2e33c4abaebb62",
"ClientRectangle": "520,60,170,70",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "507a095b4e7d47d6a96720b09b5ab5f4",
"Path": "Test.TranStatus",
"Value": "this[\"Status\"]",
"IsExpression": true
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits"
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "462fdcad2da6436a894c49f747a8452f",
"Expression": "Count(Test.Type)",
"Label": "Type"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"GlyphColor": "Yellow",
"Font": ";13;Bold;",
"Style": "SlateGray"
},
"1": {
"Ident": "StiChartElement",
"Name": "Chart4",
"Guid": "3dd34ea5a0ec4c0c85f3b94db2c0a0c8",
"ClientRectangle": "0,400,280,200",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "84f09b96b90a4d5cbcc0501ddb8ecb75",
"Path": "Test.Type",
"Value": "Suspense"
},
"1": {
"Key": "33436622001b4972aeb35f2829244b73",
"Path": "Test.TranStatus",
"Value": "this[\"Status\"]",
"IsExpression": true
}
},
"Values": {
"0": {
"Ident": "ValueChartMeter",
"Key": "a00ba4fcdb6142b09d90d4001e4b3ce3",
"Expression": "Count(Test.Type)",
"Label": "Type",
"SeriesType": "Pie"
}
},
"Arguments": {
"0": {
"Ident": "ArgumentChartMeter",
"Key": "a5d694e8c1c549f9b8b6fd606481c291",
"Expression": "Test.AssignedTo",
"Label": "Assigned To"
}
},
"DashboardInteraction": {
"Ident": "Chart",
"OnHover": "ShowToolTip",
"OnClick": "ApplyFilter",
"HyperlinkDestination": "NewTab"
},
"Title": {
"Text": "Chart",
"Visible": false
},
"ArgumentFormat": {
"Ident": "StiGeneralFormatService"
},
"ValueFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits, Abbreviation"
},
"Area": {
"GridLinesHor": {
"Color": "Transparent",
"Visible": true
},
"GridLinesVert": {
"Color": "Transparent"
},
"InterlacingHor": {
"Color": "Transparent"
},
"InterlacingVert": {
"Color": "Transparent"
}
},
"Labels": {
"Position": "Center"
}
},
"2": {
"Ident": "StiChartElement",
"Name": "Chart5",
"Guid": "f3a32aad5cf94b99b7f19480981f0e8d",
"ClientRectangle": "280,400,920,200",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "fa6f0ae245e047029b73a299eb5cd6a5",
"Path": "Test.TranStatus",
"Value": "this.[\"Status\"]",
"IsExpression": true
}
},
"Values": {
"0": {
"Ident": "ValueChartMeter",
"Key": "623ac4b9043b48e6a5f14a96161324e1",
"Expression": "Count(Test.Sender)",
"Label": "Sender"
}
},
"DashboardInteraction": {
"Ident": "Chart",
"OnHover": "ShowToolTip",
"OnClick": "ApplyFilter",
"HyperlinkDestination": "NewTab"
},
"Title": {
"Text": "Chart",
"Visible": false
},
"Series": {
"Ident": "SeriesChartMeter",
"Key": "4a40a07d5a1740eaaeff2e6dddd7a123",
"Expression": "Test.Sender",
"Label": "Sender"
},
"ArgumentFormat": {
"Ident": "StiGeneralFormatService"
},
"ValueFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits, Abbreviation"
},
"YAxis": {
"Title": {
"Visible": false
}
},
"Legend": {
"HorAlignment": "Center",
"Visibility": "Always"
},
"Area": {
"GridLinesHor": {
"Color": "Transparent",
"Visible": true
},
"GridLinesVert": {
"Color": "Transparent"
},
"InterlacingHor": {
"Color": "Transparent"
},
"InterlacingVert": {
"Color": "Transparent"
}
},
"Labels": {
"Position": "OutsideEnd",
"Style": "Value"
}
},
"3": {
"Ident": "StiTextElement",
"Name": "Text15",
"Guid": "059464f3a31a405fbb107c450f81066a",
"ClientRectangle": "0,130,1200,30",
"Border": "All;128,128,128;;;",
"Text": "Month Totals",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"4": {
"Ident": "StiChartElement",
"Name": "Chart6",
"Guid": "199c133156e04057a18e39a7b54ad4b5",
"ClientRectangle": "0,160,1200,210",
"Border": "All;128,128,128;;;",
"UserSorts": {
"0": {
"Key": "81cd58ec16f641e88e681163f1fee9d9"
}
},
"DataFilters": {
"0": {
"Key": "08bfacf7794445d3b1dc565717a236ed",
"Path": "Test.Type",
"Value": "Suspense"
},
"1": {
"Key": "d66cc6d8e28a4492874f43edec679c0b",
"Path": "Test.TranStatus",
"Value": "this[\"Status\"]",
"IsExpression": true
}
},
"Values": {
"0": {
"Ident": "ValueChartMeter",
"Key": "73a9f92bda984f3486487502d35a02f8",
"Expression": "Count(Test.Type)",
"Label": "Total # Transactions",
"SeriesType": "Spline"
},
"1": {
"Ident": "ValueChartMeter",
"Key": "b9483356aec94a9d90c059a2987e85b0",
"Expression": "DistinctCount(Test.Sender)",
"Label": "Total # Senders",
"SeriesType": "Spline",
"YAxis": "RightYAxis",
"LineStyle": "Dash"
}
},
"Arguments": {
"0": {
"Ident": "ArgumentChartMeter",
"Key": "89e915f9d8ce42e3a65932fb30c27346",
"Expression": "Test.YearMonthNum",
"Label": "YearMonthNum"
}
},
"DashboardInteraction": {
"Ident": "Chart",
"OnHover": "ShowToolTip",
"OnClick": "ApplyFilter",
"HyperlinkDestination": "NewTab"
},
"Title": {
"Text": "Chart",
"Visible": false
},
"ArgumentFormat": {
"Ident": "StiGeneralFormatService"
},
"ValueFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits"
},
"XAxis": {
"Title": {
"Visible": false
}
},
"YAxis": {
"Labels": {
"Placement": "OneLine"
},
"Title": {
"Visible": false
}
},
"YRightAxis": {
"Title": {
"Visible": false
},
"Visible": true
},
"Legend": {
"HorAlignment": "Center"
},
"Area": {
"GridLinesHor": {
"Color": "Transparent",
"Visible": true
},
"GridLinesVert": {
"Color": "Transparent"
},
"InterlacingHor": {
"Color": "Transparent"
},
"InterlacingVert": {
"Color": "Transparent"
}
},
"Labels": {
"Font": ";11;Bold;",
"Position": "OutsideEnd",
"Style": "Value"
}
},
"5": {
"Ident": "StiTextElement",
"Name": "Text19",
"Guid": "f1dc553f970644afb5527a5f3add04fb",
"ClientRectangle": "340,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "# Senders",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"6": {
"Ident": "StiIndicatorElement",
"Name": "Indicator8",
"Guid": "de430ea67cb44b51aa7b51afd63e9584",
"ClientRectangle": "340,60,170,70",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "f8a0bb6f3250413a8e701f61d89ad345",
"Path": "Test.Type",
"Value": "Transaction"
},
"1": {
"Key": "cd0dd58bf47e4aac9514de5b1b841c6b",
"Path": "Test.TranStatus",
"Value": "this[\"Status\"]",
"IsExpression": true
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits"
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "32133ea4a9444faaaf28e4d737340e06",
"Expression": "DistinctCount(Test.Sender)",
"Label": "Sender"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"GlyphColor": "Red",
"Font": ";16;Bold;",
"Style": "SlateGray",
"Icon": "Envelope"
},
"7": {
"Ident": "StiTextElement",
"Name": "Text21",
"Guid": "b939e73a8f92457ab7b466606d8eb365",
"ClientRectangle": "340,0,520,30",
"Border": "All;128,128,128;;;",
"Text": "Totals",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"8": {
"Ident": "StiTextElement",
"Name": "Text23",
"Guid": "5889b04ea32a4024a7fe56db263e1623",
"ClientRectangle": "520,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "# Transactions",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"9": {
"Ident": "StiTextElement",
"Name": "Text24",
"Guid": "940c5568d9594e57b4700a79da08d328",
"ClientRectangle": "0,370,280,30",
"Border": "All;128,128,128;;;",
"Text": "Assigned To",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"10": {
"Ident": "StiTextElement",
"Name": "Text25",
"Guid": "20319ec67dda4c26a41ebcea1028c606",
"ClientRectangle": "280,370,920,30",
"Border": "All;128,128,128;;;",
"Text": "Sender Breakdown",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"11": {
"Ident": "StiIndicatorElement",
"Name": "Indicator10",
"Guid": "8b746e37586843489aba1414d595c640",
"ClientRectangle": "690,60,170,70",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "a4c316d260764c3c9bd43a824980ad28",
"Path": "Test.Type",
"Value": "Suspense"
},
"1": {
"Key": "24cec1c2c609458fb81fc97ae9990a9f",
"Path": "Test.TranStatus",
"Value": "this[\"Status\"]",
"IsExpression": true
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiCurrencyFormatService",
"NegativePattern": 0,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits",
"PositivePattern": 0
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "a726afd035e841fb90e1dda5d3eccace",
"Expression": "Sum(Test.TotalValue)",
"Label": "Total Value"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"GlyphColor": "160,48,200",
"Font": ";16;Bold;",
"Style": "SlateGray",
"Icon": "Gbp"
},
"12": {
"Ident": "StiTextElement",
"Name": "Text26",
"Guid": "32a7b467e78d4da5b8d4dc7585056511",
"ClientRectangle": "690,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "£ Suspense",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
}
},
"Border": ";;2;;;;;solid:Black"
},
"3": {
"Ident": "StiDashboard",
"Name": "Assigned_To_Detail",
"Guid": "50a4799f4804486b9ea08c7fa99a8b04",
"Brush": "solid:",
"Components": {
"0": {
"Ident": "StiIndicatorElement",
"Name": "Indicator9",
"Guid": "84e94de079d2440e8c2e33c4abaebb62",
"ClientRectangle": "520,60,170,70",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "507a095b4e7d47d6a96720b09b5ab5f4",
"Path": "[Test.Assigned To]",
"Value": "this[\"AssignedTo\"]",
"IsExpression": true
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits"
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "462fdcad2da6436a894c49f747a8452f",
"Expression": "Count(Test.Type)",
"Label": "Type"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"GlyphColor": "Yellow",
"Font": ";13;Bold;",
"Style": "SlateGray"
},
"1": {
"Ident": "StiChartElement",
"Name": "Chart8",
"Guid": "f3a32aad5cf94b99b7f19480981f0e8d",
"ClientRectangle": "0,400,580,200",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "fa6f0ae245e047029b73a299eb5cd6a5",
"Path": "[Test.Assigned To]",
"Value": "this.[\"AssignedTo\"]",
"IsExpression": true
}
},
"Values": {
"0": {
"Ident": "ValueChartMeter",
"Key": "65b11f5c26fb414580b50ac396687f26",
"Expression": "Count(Test.TranStatus)",
"Label": "Tran Status"
}
},
"DashboardInteraction": {
"Ident": "Chart",
"OnHover": "ShowToolTip",
"OnClick": "ApplyFilter",
"HyperlinkDestination": "NewTab"
},
"Title": {
"Text": "Chart",
"Visible": false
},
"Series": {
"Ident": "SeriesChartMeter",
"Key": "f3b52ba7d7ae4372b87e95c3335300f8",
"Expression": "Test.TranStatus",
"Label": "Tran Status"
},
"ArgumentFormat": {
"Ident": "StiGeneralFormatService"
},
"ValueFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits, Abbreviation"
},
"YAxis": {
"Title": {
"Visible": false
}
},
"Legend": {
"HorAlignment": "Center",
"Visibility": "Always"
},
"Area": {
"GridLinesHor": {
"Color": "Transparent",
"Visible": true
},
"GridLinesVert": {
"Color": "Transparent"
},
"InterlacingHor": {
"Color": "Transparent"
},
"InterlacingVert": {
"Color": "Transparent"
}
},
"Labels": {
"Position": "OutsideEnd",
"Style": "Value"
}
},
"2": {
"Ident": "StiTextElement",
"Name": "Text14",
"Guid": "059464f3a31a405fbb107c450f81066a",
"ClientRectangle": "0,130,1200,30",
"Border": "All;128,128,128;;;",
"Text": "Month Totals",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"3": {
"Ident": "StiChartElement",
"Name": "Chart9",
"Guid": "199c133156e04057a18e39a7b54ad4b5",
"ClientRectangle": "0,160,1200,210",
"Border": "All;128,128,128;;;",
"UserSorts": {
"0": {
"Key": "81cd58ec16f641e88e681163f1fee9d9"
}
},
"DataFilters": {
"0": {
"Key": "08bfacf7794445d3b1dc565717a236ed",
"Path": "Test.Type",
"Value": "Suspense"
},
"1": {
"Key": "d66cc6d8e28a4492874f43edec679c0b",
"Path": "[Test.Assigned To]",
"Value": "this[\"AssignedTo\"]",
"IsExpression": true
}
},
"Values": {
"0": {
"Ident": "ValueChartMeter",
"Key": "73a9f92bda984f3486487502d35a02f8",
"Expression": "Count(Test.Type)",
"Label": "Total # Transactions",
"SeriesType": "Spline"
},
"1": {
"Ident": "ValueChartMeter",
"Key": "b9483356aec94a9d90c059a2987e85b0",
"Expression": "DistinctCount(Test.Sender)",
"Label": "Total # Senders",
"SeriesType": "Spline",
"YAxis": "RightYAxis",
"LineStyle": "Dash"
}
},
"Arguments": {
"0": {
"Ident": "ArgumentChartMeter",
"Key": "89e915f9d8ce42e3a65932fb30c27346",
"Expression": "Test.YearMonthNum",
"Label": "YearMonthNum"
}
},
"DashboardInteraction": {
"Ident": "Chart",
"OnHover": "ShowToolTip",
"OnClick": "ApplyFilter",
"HyperlinkDestination": "NewTab"
},
"Title": {
"Text": "Chart",
"Visible": false
},
"ArgumentFormat": {
"Ident": "StiGeneralFormatService"
},
"ValueFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits"
},
"XAxis": {
"Title": {
"Visible": false
}
},
"YAxis": {
"Labels": {
"Placement": "OneLine"
},
"Title": {
"Visible": false
}
},
"YRightAxis": {
"Title": {
"Visible": false
},
"Visible": true
},
"Legend": {
"HorAlignment": "Center"
},
"Area": {
"GridLinesHor": {
"Color": "Transparent",
"Visible": true
},
"GridLinesVert": {
"Color": "Transparent"
},
"InterlacingHor": {
"Color": "Transparent"
},
"InterlacingVert": {
"Color": "Transparent"
}
},
"Labels": {
"Font": ";11;Bold;",
"Position": "OutsideEnd",
"Style": "Value"
}
},
"4": {
"Ident": "StiTextElement",
"Name": "Text16",
"Guid": "f1dc553f970644afb5527a5f3add04fb",
"ClientRectangle": "340,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "# Senders",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"5": {
"Ident": "StiIndicatorElement",
"Name": "Indicator11",
"Guid": "de430ea67cb44b51aa7b51afd63e9584",
"ClientRectangle": "340,60,170,70",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "f8a0bb6f3250413a8e701f61d89ad345",
"Path": "Test.Type",
"Value": "Transaction"
},
"1": {
"Key": "cd0dd58bf47e4aac9514de5b1b841c6b",
"Path": "[Test.Assigned To]",
"Value": "this[\"AssignedTo\"]",
"IsExpression": true
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits"
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "32133ea4a9444faaaf28e4d737340e06",
"Expression": "DistinctCount(Test.Sender)",
"Label": "Sender"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"GlyphColor": "Red",
"Font": ";16;Bold;",
"Style": "SlateGray",
"Icon": "Envelope"
},
"6": {
"Ident": "StiTextElement",
"Name": "Text17",
"Guid": "b939e73a8f92457ab7b466606d8eb365",
"ClientRectangle": "340,0,520,30",
"Border": "All;128,128,128;;;",
"Text": "Totals",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"7": {
"Ident": "StiTextElement",
"Name": "Text18",
"Guid": "5889b04ea32a4024a7fe56db263e1623",
"ClientRectangle": "520,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "# Transactions",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"8": {
"Ident": "StiTextElement",
"Name": "Text20",
"Guid": "940c5568d9594e57b4700a79da08d328",
"ClientRectangle": "0,370,580,30",
"Border": "All;128,128,128;;;",
"Text": "Action Type Breakdown",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"9": {
"Ident": "StiTextElement",
"Name": "Text22",
"Guid": "20319ec67dda4c26a41ebcea1028c606",
"ClientRectangle": "600,370,600,30",
"Border": "All;128,128,128;;;",
"Text": "Sender Breakdown",
"Title": {
"Text": "Text",
"Visible": false,
"HorAlignment": "Center"
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"10": {
"Ident": "StiIndicatorElement",
"Name": "Indicator12",
"Guid": "8b746e37586843489aba1414d595c640",
"ClientRectangle": "690,60,170,70",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "a4c316d260764c3c9bd43a824980ad28",
"Path": "Test.Type",
"Value": "Suspense"
},
"1": {
"Key": "24cec1c2c609458fb81fc97ae9990a9f",
"Path": "[Test.Assigned To]",
"Value": "this[\"AssignedTo\"]",
"IsExpression": true
}
},
"DashboardInteraction": {
"Ident": "Indicator",
"OnHover": "ShowToolTip",
"OnClick": "None",
"HyperlinkDestination": "NewTab"
},
"TextFormat": {
"Ident": "StiCurrencyFormatService",
"NegativePattern": 0,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits",
"PositivePattern": 0
},
"Value": {
"Ident": "ValueIndicatorMeter",
"Key": "a726afd035e841fb90e1dda5d3eccace",
"Expression": "Sum(Test.TotalValue)",
"Label": "Total Value"
},
"Title": {
"Text": "Indicator",
"Visible": false
},
"GlyphColor": "160,48,200",
"Font": ";16;Bold;",
"Style": "SlateGray",
"Icon": "Gbp"
},
"11": {
"Ident": "StiTextElement",
"Name": "Text27",
"Guid": "32a7b467e78d4da5b8d4dc7585056511",
"ClientRectangle": "690,30,170,30",
"Border": "All;128,128,128;;;",
"Text": "£ Suspense",
"Title": {
"Text": "Text",
"Visible": false
},
"DashboardInteraction": {
"Ident": "Text",
"OnHover": "ShowToolTip",
"OnClick": "OpenHyperlink",
"HyperlinkDestination": "NewTab"
}
},
"12": {
"Ident": "StiChartElement",
"Name": "Chart7",
"Guid": "3df0fd661f3d421eb24bd25cd1f67924",
"ClientRectangle": "600,400,600,200",
"Border": "All;128,128,128;;;",
"DataFilters": {
"0": {
"Key": "fa6f0ae245e047029b73a299eb5cd6a5",
"Path": "[Test.Assigned To]",
"Value": "this.[\"AssignedTo\"]",
"IsExpression": true
}
},
"Values": {
"0": {
"Ident": "ValueChartMeter",
"Key": "623ac4b9043b48e6a5f14a96161324e1",
"Expression": "Count(Test.Sender)",
"Label": "Sender"
}
},
"DashboardInteraction": {
"Ident": "Chart",
"OnHover": "ShowToolTip",
"OnClick": "ApplyFilter",
"HyperlinkDestination": "NewTab"
},
"Title": {
"Text": "Chart",
"Visible": false
},
"Series": {
"Ident": "SeriesChartMeter",
"Key": "4a40a07d5a1740eaaeff2e6dddd7a123",
"Expression": "Test.Sender",
"Label": "Sender"
},
"ArgumentFormat": {
"Ident": "StiGeneralFormatService"
},
"ValueFormat": {
"Ident": "StiNumberFormatService",
"NegativePattern": 1,
"DecimalDigits": 0,
"GroupSeparator": ",",
"State": "DecimalDigits, Abbreviation"
},
"YAxis": {
"Title": {
"Visible": false
}
},
"Legend": {
"HorAlignment": "Center",
"Visibility": "Always"
},
"Area": {
"GridLinesHor": {
"Color": "Transparent",
"Visible": true
},
"GridLinesVert": {
"Color": "Transparent"
},
"InterlacingHor": {
"Color": "Transparent"
},
"InterlacingVert": {
"Color": "Transparent"
}
},
"Labels": {
"Position": "OutsideEnd",
"Style": "Value"
}
}
},
"Border": ";;2;;;;;solid:Black"
}
}
}