ResourceKey: e4ca1c9f-51fd-40a5-828c-4e671b33e2fb ModelId: 1123181 Entity: dashboard_2018_2022 Filters: aging=1L (65+), age_subgroup=2L (70-74), type_of_vehicle in [11L,12L] (motorcycle,moped), all genders, all districts MIAMI-DADE rows: [[2018, 14], [2019, 14], [2020, 10], [2021, 9], [2022, 13]] PALM BEACH rows: [[2018, 9], [2019, 11], [2020, 11], [2021, 4], [2022, 12]] Raw Miami response snippet: { "jobIds": [ "6e4f550a-c5ec-40ef-aaf0-773c583fe9a8" ], "results": [ { "jobId": "6e4f550a-c5ec-40ef-aaf0-773c583fe9a8", "result": { "data": { "timestamp": "2026-03-13T07:03:51.288Z", "rootActivityId": "dd73549e-749a-483f-96f5-ec9cdb29d1da", "descriptor": { "Select": [ { "Kind": 1, "Depth": 0, "Value": "G0", "Format": "0", "GroupKeys": [ { "Source": { "Entity": "dashboard_2018_2022", "Property": "Year" }, "Calc": "G0", "IsSameAsSelect": true } ], "Name": "Year" }, { "Kind": 2, "Value": "M0", "Format": "#,0", "Subtotal": [ "A0" ], "Name": "Count of Crashes" } ], "Expressions": { "Primary": { "Groupings": [ { "Keys": [ { "Source": { "Entity": "dashboard_2018_2022", "Property": "Year" }, "Select": 0 } ], "Member": "DM1", "SubtotalMember": "DM0" } ] } }, "Version": 2 }, "metrics": { "Version": "1.0.0", "Events": [ { "Id": "437ee2f0-aa3e-4aee-a463-5d523b53e993", "Name": "Execute Semantic Query", "Component": "DSE", "Start": "2026-03-13T07:03:51.2880498Z", "End": "2026-03-13T07:03:51.3192997Z" }, { "Id": "ffe8cc31-8cbe-42f2-bf7c-5049ea974582", "ParentId": "437ee2f0-aa3e-4aee-a463-5d523b53e993", "Name": "Execute DAX Query", "Component": "DSE", "Start": "2026-03-13T07:03:51.2880498Z", "End": "2026-03-13T07:03:51.3192997Z", "Metrics": { "RowCount": 6 } }, { "Id": "B66459DA-B60C-46A5-BD7D-CE9C3C27E49D", "ParentId": "ffe8cc31-8cbe-42f2-bf7c-5049ea974582", "Name": "Execute Query", "Component": "AS", "Start": "2026-03-13T07:03:51.31Z", "End": "2026-03-13T07:03:51.317Z" }, { "Id": "2FAFCCB4-3C17-417F-ACC2-405709C4DBBC", "ParentId": "B66459DA-B60C-46A5-BD7D-CE9C3C27E49D", "Name": "Serialize Rowset", "Component": "AS", "Start": "2026-03-13T07:03:51.317Z", "End": "2026-03-13T07:03:51.317Z" } ] }, "fromCache": false, "dsr": { "Version": 2, "MinorVersion": 1, "DS": [ { "N": "DS0", "PH": [ { "DM0": [ { "S": [ { "N": "A0", "T": 4 } ], "A0": 60 } ] }, { "DM1": [ { "S": [ { "N": "G0", "T": 4 }, { "N": "M0", "T": 4 } ], "C": [ 2018, 14 ] }, { "C": [ 2019 ], "R": 2 }, { "C": [ 2020, 10 ] }, { "C": [ 2021, 9 ] }, { "C": [ 2022, 13 ] } ] } ], "IC": true, "HAD": true } ] } } } } ] } Raw Palm response snippet: { "jobIds": [ "fbdd26a1-2553-44f7-a4a8-eefee3485859" ], "results": [ { "jobId": "fbdd26a1-2553-44f7-a4a8-eefee3485859", "result": { "data": { "timestamp": "2026-03-13T07:03:51.944Z", "rootActivityId": "f5fd4c22-ed79-4d32-82d1-205431dc22d3", "descriptor": { "Select": [ { "Kind": 1, "Depth": 0, "Value": "G0", "Format": "0", "GroupKeys": [ { "Source": { "Entity": "dashboard_2018_2022", "Property": "Year" }, "Calc": "G0", "IsSameAsSelect": true } ], "Name": "Year" }, { "Kind": 2, "Value": "M0", "Format": "#,0", "Subtotal": [ "A0" ], "Name": "Count of Crashes" } ], "Expressions": { "Primary": { "Groupings": [ { "Keys": [ { "Source": { "Entity": "dashboard_2018_2022", "Property": "Year" }, "Select": 0 } ], "Member": "DM1", "SubtotalMember": "DM0" } ] } }, "Version": 2 }, "metrics": { "Version": "1.0.0", "Events": [ { "Id": "9196e0f9-f540-46a1-a865-04e01a3645dd", "Name": "Execute Semantic Query", "Component": "DSE", "Start": "2026-03-13T07:03:51.94453Z", "End": "2026-03-13T07:03:52.0694953Z" }, { "Id": "400d6a21-869a-4ca0-9dad-f8f79df74c9a", "ParentId": "9196e0f9-f540-46a1-a865-04e01a3645dd", "Name": "Execute DAX Query", "Component": "DSE", "Start": "2026-03-13T07:03:52.0382413Z", "End": "2026-03-13T07:03:52.0694953Z", "Metrics": { "RowCount": 6 } }, { "Id": "E2839D56-74C6-48E5-9EAE-293B552CEABD", "ParentId": "400d6a21-869a-4ca0-9dad-f8f79df74c9a", "Name": "Execute Query", "Component": "AS", "Start": "2026-03-13T07:03:52.063Z", "End": "2026-03-13T07:03:52.07Z" }, { "Id": "E42B670A-B0B3-46DB-943E-D0959F6C12D0", "ParentId": "E2839D56-74C6-48E5-9EAE-293B552CEABD", "Name": "Serialize Rowset", "Component": "AS", "Start": "2026-03-13T07:03:52.07Z", "End": "2026-03-13T07:03:52.07Z" } ] }, "fromCache": false, "dsr": { "Version": 2, "MinorVersion": 1, "DS": [ { "N": "DS0", "PH": [ { "DM0": [ { "S": [ { "N": "A0", "T": 4 } ], "A0": 47 } ] }, { "DM1": [ { "S": [ { "N": "G0", "T": 4 }, { "N": "M0", "T": 4 } ], "C": [ 2018, 9 ] }, { "C": [ 2019, 11 ] }, { "C": [ 2020 ], "R": 2 }, { "C": [ 2021, 4 ] }, { "C": [ 2022, 12 ] } ] } ], "IC": true, "HAD": true } ] } } } } ] }