{"jobIds":["b1f5e1d0-8171-4cef-8d67-2d7e0f9308b4","9cc30d8a-5974-4f52-b044-cecc669a2e4c","5c1287dd-d7da-4a9e-a960-5c6a52f7992b","4de956e3-d92d-428d-84e5-ceb374738f84"],"results":[{"jobId":"b1f5e1d0-8171-4cef-8d67-2d7e0f9308b4","result":{"data":{"timestamp":"2024-03-30T16:44:07.708Z","rootActivityId":"5ece71ff-ce5a-4750-9f49-d770e1a8d8e1","descriptor":{"Select":[{"Kind":2,"Value":"M0","Format":"0","Min":["A0"],"Max":["A1"],"Aggregates":[{"Ids":["A0"],"Aggregate":{"Min":{}}},{"Ids":["A1"],"Aggregate":{"Max":{}}}],"Name":"Measures Table.Application Count"},{"Kind":1,"Depth":0,"Value":"G0","GroupKeys":[{"Source":{"Entity":"Offence Type Legend","Property":"Offence Type"},"Calc":"G0","IsSameAsSelect":true}],"Name":"Offence Type Legend.Offence Type"}],"Expressions":{"Primary":{"Groupings":[{"Keys":[{"Source":{"Entity":"Offence Type Legend","Property":"Offence Type"},"Select":1}],"Member":"DM0"}]}},"Version":2},"metrics":{"Version":"1.0.0","Events":[{"Id":"af6730ef-10e4-4aab-bc49-2c63d16d40f3","Name":"Execute Semantic Query","Component":"DSE","Start":"2024-03-30T16:44:07.7082406Z","End":"2024-03-30T16:44:07.7395388Z"},{"Id":"461f7c3a-a2f1-49c9-a3f0-0ad7f816b047","ParentId":"af6730ef-10e4-4aab-bc49-2c63d16d40f3","Name":"Execute DAX Query","Component":"DSE","Start":"2024-03-30T16:44:07.7082406Z","End":"2024-03-30T16:44:07.7395388Z","Metrics":{"RowCount":10}},{"Id":"E68A6455-CAA1-4D9F-9E80-A0729DE5CB44","ParentId":"461f7c3a-a2f1-49c9-a3f0-0ad7f816b047","Name":"Execute Query","Component":"AS","Start":"2024-03-30T16:44:07.73Z","End":"2024-03-30T16:44:07.737Z"},{"Id":"62E2D93A-8680-4720-B125-B4FA5B90B8B1","ParentId":"E68A6455-CAA1-4D9F-9E80-A0729DE5CB44","Name":"Serialize Rowset","Component":"AS","Start":"2024-03-30T16:44:07.737Z","End":"2024-03-30T16:44:07.737Z"}]},"fromCache":false,"dsr":{"Version":2,"MinorVersion":1,"DS":[{"N":"DS0","S":[{"N":"A0","T":4},{"N":"A1","T":4}],"C":[9,103],"PH":[{"DM0":[{"S":[{"N":"G0","T":1,"DN":"D0"},{"N":"M0","T":4}],"C":[0,69]},{"C":[1,103]},{"C":[2,92]},{"C":[3,91]},{"C":[4,16]},{"C":[5,35]},{"C":[6,33]},{"C":[7,54]},{"C":[8,9]}]}],"IC":true,"HAD":true,"ValueDicts":{"D0":["Murder/Manslaughter","Sexual (adult)","Sexual (minor)","Violence","Family harm/violence (non-violent)","Dishonesty/fraud/financial","Drugs","Other","Not disclosed"]}}]}}}},{"jobId":"9cc30d8a-5974-4f52-b044-cecc669a2e4c","result":{"data":{"timestamp":"2024-03-30T16:44:07.723Z","rootActivityId":"1e7a6ebc-7a09-4712-ab44-56fcbe9d7caf","descriptor":{"Select":[{"Kind":2,"Value":"M0","Format":"0","Name":"Measures Table.Application Count with Blank"},{"Kind":1,"SecondaryDepth":0,"Value":"G1","Format":"0","GroupKeys":[{"Source":{"Entity":"Report Dates","Property":"Year"},"Calc":"G1","IsSameAsSelect":true}],"Name":"Report Dates.Year"},{"Kind":1,"Depth":0,"Value":"G0","GroupKeys":[{"Source":{"Entity":"Report Dates","Property":"Month Name"},"Calc":"G0","IsSameAsSelect":true}],"Name":"Report Dates.Month Name"}],"Expressions":{"Primary":{"Groupings":[{"Keys":[{"Source":{"Entity":"Report Dates","Property":"Month Name"},"Select":2}],"Member":"DM0"}]},"Secondary":{"Groupings":[{"Keys":[{"Source":{"Entity":"Report Dates","Property":"Year"},"Select":1}],"Member":"DM1"}]}},"Limits":{"Secondary":{"Id":"L0","Top":{"Count":100}}},"Version":2},"metrics":{"Version":"1.0.0","Events":[{"Id":"04a9e52e-5ea8-4b09-9c19-51b3bd48f867","Name":"Execute Semantic Query","Component":"DSE","Start":"2024-03-30T16:44:07.7238671Z","End":"2024-03-30T16:44:07.7551177Z"},{"Id":"063b3dee-d740-4451-9b0d-1f7670ab62c7","ParentId":"04a9e52e-5ea8-4b09-9c19-51b3bd48f867","Name":"Execute DAX Query","Component":"DSE","Start":"2024-03-30T16:44:07.7395388Z","End":"2024-03-30T16:44:07.7551177Z","Metrics":{"RowCount":49}},{"Id":"8A22E482-8BC6-43DD-B33C-D9B631F0834E","ParentId":"063b3dee-d740-4451-9b0d-1f7670ab62c7","Name":"Execute Query","Component":"AS","Start":"2024-03-30T16:44:07.753Z","End":"2024-03-30T16:44:07.757Z"},{"Id":"7F22D44F-6AAD-469E-AC47-EB89BC96D5EC","ParentId":"8A22E482-8BC6-43DD-B33C-D9B631F0834E","Name":"Serialize Rowset","Component":"AS","Start":"2024-03-30T16:44:07.757Z","End":"2024-03-30T16:44:07.757Z"}]},"fromCache":false,"dsr":{"Version":2,"MinorVersion":1,"DS":[{"N":"DS0","SH":[{"DM1":[{"S":[{"N":"G1","T":3}],"G1":2024},{"G1":2023},{"G1":2022},{"G1":2021},{"G1":2020}]}],"PH":[{"DM0":[{"S":[{"N":"G0","T":1,"DN":"D0"}],"G0":0,"X":[{"S":[{"N":"M0","T":4}],"M0":2},{"M0":7},{"M0":1},{"M0":23}]},{"G0":1,"X":[{"M0":10},{"M0":6},{"M0":8},{"M0":12}]},{"G0":2,"X":[{"I":1,"M0":9},{"M0":7},{"R":1}]},{"G0":3,"X":[{"I":1,"M0":3},{"M0":5},{"M0":15}]},{"G0":4,"X":[{"I":1,"M0":9},{"M0":6},{"M0":9}]},{"G0":5,"X":[{"I":1,"M0":8},{"M0":7},{"M0":13}]},{"G0":6,"X":[{"I":1,"M0":8},{"M0":7},{"M0":18},{"M0":43}]},{"G0":7,"X":[{"I":1,"M0":6},{"M0":10},{"M0":11},{"M0":18}]},{"G0":8,"X":[{"I":1,"M0":7},{"M0":6},{"M0":5},{"M0":19}]},{"G0":9,"X":[{"I":1,"M0":3},{"R":1},{"M0":4},{"M0":21}]},{"G0":10,"X":[{"I":1,"M0":5},{"R":1},{"M0":9},{"M0":24}]},{"G0":11,"X":[{"I":1,"M0":6},{"M0":5},{"M0":7},{"M0":17}]}]}],"IC":true,"HAD":true,"ValueDicts":{"D0":["January","February","March","April","May","June","July","August","September","October","November","December"]}}]}}}},{"jobId":"5c1287dd-d7da-4a9e-a960-5c6a52f7992b","result":{"data":{"timestamp":"2024-03-30T16:44:07.739Z","rootActivityId":"f6f862d7-c149-4993-b610-4f4b8b9fe00b","descriptor":{"Select":[{"Kind":2,"Value":"M0","Format":"0","Min":["A0"],"Max":["A1"],"Aggregates":[{"Ids":["A0"],"Aggregate":{"Min":{}}},{"Ids":["A1"],"Aggregate":{"Max":{}}}],"Name":"Measures Table.Application Count"},{"Kind":1,"Depth":0,"Value":"G0","GroupKeys":[{"Source":{"Entity":"Statement of Reasons Legend","Property":"Statement of Reason"},"Calc":"G0","IsSameAsSelect":true}],"Name":"Statement of Reasons Legend.Statement of Reason"}],"Expressions":{"Primary":{"Groupings":[{"Keys":[{"Source":{"Entity":"Statement of Reasons Legend","Property":"Statement of Reason"},"Select":1}],"Member":"DM0"}]}},"Version":2},"metrics":{"Version":"1.0.0","Events":[{"Id":"4bc48ccc-28bc-45c0-9e11-01e62cba370e","Name":"Execute Semantic Query","Component":"DSE","Start":"2024-03-30T16:44:07.7395388Z","End":"2024-03-30T16:44:07.7707416Z"},{"Id":"fcd55e10-2e7a-47ac-b1d2-3cceb79ec2e2","ParentId":"4bc48ccc-28bc-45c0-9e11-01e62cba370e","Name":"Execute DAX Query","Component":"DSE","Start":"2024-03-30T16:44:07.7395388Z","End":"2024-03-30T16:44:07.7707416Z","Metrics":{"RowCount":10}},{"Id":"76FA9D12-16C1-44B9-AA27-D64B36B75118","ParentId":"fcd55e10-2e7a-47ac-b1d2-3cceb79ec2e2","Name":"Execute Query","Component":"AS","Start":"2024-03-30T16:44:07.763Z","End":"2024-03-30T16:44:07.77Z"},{"Id":"E410AF7C-2215-4284-9297-F843F5C3B81C","ParentId":"76FA9D12-16C1-44B9-AA27-D64B36B75118","Name":"Serialize Rowset","Component":"AS","Start":"2024-03-30T16:44:07.77Z","End":"2024-03-30T16:44:07.77Z"}]},"fromCache":false,"dsr":{"Version":2,"MinorVersion":1,"DS":[{"N":"DS0","S":[{"N":"A0","T":4},{"N":"A1","T":4}],"C":[0,86],"PH":[{"DM0":[{"S":[{"N":"G0","T":1,"DN":"D0"},{"N":"M0","T":4}],"C":[0,9]},{"C":[1,48]},{"C":[2,6]},{"C":[3,0]},{"C":[4,6]},{"C":[5,1]},{"C":[6,86]},{"C":[7,2]},{"C":[8,9]}]}],"IC":true,"HAD":true,"ValueDicts":{"D0":["No criminal conviction","Appeals processes available","Application withdrawn","Frivolous/vexatious or not in good faith","Incomplete application","Applicant deceased","Not in the interests of justice","Active appeal on the same grounds","Other"]}}]}}}},{"jobId":"4de956e3-d92d-428d-84e5-ceb374738f84","result":{"data":{"timestamp":"2024-03-30T16:44:07.739Z","rootActivityId":"220491cd-ff22-4f38-95e0-aac41fb9b1c7","descriptor":{"Select":[{"Kind":1,"Depth":0,"Value":"G0","GroupKeys":[{"Source":{"Entity":"Case Age Groups Legend","Property":"Case Age Group"},"Calc":"G0","IsSameAsSelect":true}],"Name":"Case Age Groups Legend.Case Age Group"},{"Kind":2,"Value":"M0","Format":"0","Min":["A0"],"Max":["A1"],"Aggregates":[{"Ids":["A0"],"Aggregate":{"Min":{}}},{"Ids":["A1"],"Aggregate":{"Max":{}}}],"Name":"Measures Table.Application Count"}],"Expressions":{"Primary":{"Groupings":[{"Keys":[{"Source":{"Entity":"Case Age Groups Legend","Property":"Case Age Group"},"Select":0}],"Member":"DM0"}]}},"Version":2},"metrics":{"Version":"1.0.0","Events":[{"Id":"29f846dd-a0de-45ce-a489-3ce396bfa0f7","Name":"Execute Semantic Query","Component":"DSE","Start":"2024-03-30T16:44:07.7395388Z","End":"2024-03-30T16:44:07.7551177Z"},{"Id":"9bcdf4c1-d09c-4a85-a435-474f4e2f7e5e","ParentId":"29f846dd-a0de-45ce-a489-3ce396bfa0f7","Name":"Execute DAX Query","Component":"DSE","Start":"2024-03-30T16:44:07.7395388Z","End":"2024-03-30T16:44:07.7551177Z","Metrics":{"RowCount":7}},{"Id":"59722B1A-70A8-425A-B9B4-9F6893DF97D4","ParentId":"9bcdf4c1-d09c-4a85-a435-474f4e2f7e5e","Name":"Execute Query","Component":"AS","Start":"2024-03-30T16:44:07.757Z","End":"2024-03-30T16:44:07.76Z"},{"Id":"8C885963-3884-4F96-927D-7629A79C9417","ParentId":"59722B1A-70A8-425A-B9B4-9F6893DF97D4","Name":"Serialize Rowset","Component":"AS","Start":"2024-03-30T16:44:07.76Z","End":"2024-03-30T16:44:07.76Z"}]},"fromCache":false,"dsr":{"Version":2,"MinorVersion":1,"DS":[{"N":"DS0","S":[{"N":"A0","T":4},{"N":"A1","T":4}],"C":[24,205],"PH":[{"DM0":[{"S":[{"N":"G0","T":1,"DN":"D0"},{"N":"M0","T":4}],"C":[0,34]},{"C":[1,205]},{"C":[2,98]},{"C":[3,37]},{"C":[4,24]},{"C":[5,36]}]}],"IC":true,"HAD":true,"ValueDicts":{"D0":["Not disclosed","1-5 years","6-10 years","11-15 years","16-20 years","21+ years"]}}]}}}}]}