Hi All
I've been playing with the data below. I'm trying to unpivot the age ranges in power query.
When I do this and then try to load it to the data model all the decimals get removed. Instead of decimals I just get zeros.
What am I doing wrong?
Many thanks
Miles
<tbody>
</tbody>
I've been playing with the data below. I'm trying to unpivot the age ranges in power query.
When I do this and then try to load it to the data model all the decimals get removed. Instead of decimals I just get zeros.
What am I doing wrong?
Many thanks
Miles
| User Type | Severity | 0-4 Yrs | 5-7 Yrs | 8-11 Yrs | 12-15 Yrs | 16 Yrs | 17 Yrs | 18-19 Yrs | 20-24 Yrs | 25-29 Yrs | 30-39 Yrs | 40-49 Yrs | 50-59 Yrs | 60-69 Yrs | 70-79 Yrs | 80 + Yrs | Unknown |
| Pedestrians | Killed | 5.00 | 3.00 | 6.00 | 12.00 | 4.00 | 5.00 | 14.00 | 33.00 | 29.00 | 44.00 | 49.00 | 48.00 | 31.00 | 47.00 | 68.00 | 0.00 |
| Pedestrians | KSI | 227.76 | 286.25 | 517.00 | 610.25 | 121.96 | 107.56 | 237.17 | 500.14 | 438.78 | 653.73 | 675.00 | 579.03 | 503.17 | 471.39 | 475.23 | 83.10 |
| Pedal cyclists | Killed | 0.00 | 1.00 | 1.00 | 4.00 | 1.00 | 2.00 | 3.00 | 10.00 | 5.00 | 15.00 | 18.00 | 24.00 | 14.00 | 8.00 | 3.00 | 0.00 |
| Pedal cyclists | KSI | 4.47 | 34.32 | 95.59 | 230.20 | 65.08 | 68.21 | 101.05 | 354.78 | 400.25 | 779.62 | 854.73 | 554.06 | 227.60 | 109.08 | 32.85 | 64.14 |
| Motorcycle 50cc and under | Killed | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Motorcycle 50cc and under | KSI | 0.00 | 0.02 | 0.16 | 7.93 | 148.10 | 90.56 | 62.80 | 72.51 | 35.68 | 47.89 | 39.45 | 24.15 | 10.74 | 3.45 | 2.22 | 4.68 |
| Motorcycle 50cc - riders | Killed | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 3.00 | 15.00 | 52.00 | 36.00 | 45.00 | 90.00 | 52.00 | 16.00 | 6.00 | 0.00 | 0.00 |
| Motorcycle 50cc - riders | KSI | 0.00 | 0.00 | 0.00 | 12.96 | 23.83 | 202.72 | 440.61 | 919.68 | 559.13 | 847.10 | 1108.99 | 800.87 | 305.70 | 52.37 | 9.45 | 41.28 |
| Motorcycle 50cc - Passengers | Killed | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 2.00 | 1.00 | 1.00 | 1.00 | 5.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 |
| Motorcycle 50cc - Passengers | KSI | 0.00 | 0.10 | 3.98 | 4.98 | 6.31 | 7.78 | 25.63 | 38.25 | 27.15 | 24.90 | 50.50 | 27.01 | 19.60 | 2.34 | 0.18 | 4.95 |
| Car - Drivers | Killed | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 44.00 | 86.00 | 70.00 | 62.00 | 60.00 | 59.00 | 49.00 | 58.00 | 59.00 | 0.00 |
| Car - Drivers | KSI | 0.00 | 0.00 | 0.02 | 1.24 | 5.43 | 110.14 | 449.32 | 1108.02 | 864.49 | 1116.12 | 1121.97 | 934.30 | 665.84 | 534.73 | 434.12 | 43.40 |
| Car - Passengers | Killed | 5.00 | 2.00 | 2.00 | 4.00 | 11.00 | 7.00 | 27.00 | 30.00 | 20.00 | 27.00 | 18.00 | 12.00 | 10.00 | 28.00 | 34.00 | 0.00 |
| Car - Passengers | KSI | 107.98 | 65.75 | 96.99 | 134.07 | 79.96 | 156.60 | 331.74 | 577.16 | 324.27 | 364.81 | 271.94 | 240.23 | 265.49 | 261.80 | 210.47 | 45.79 |
| Bus & coach Drivers | Killed | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 | 0.00 |
| Bus & coach Drivers | KSI | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 0.01 | 0.13 | 2.42 | 5.95 | 7.43 | 7.78 | 5.07 | 0.06 | 0.05 | 0.01 |
| Bus & coach Passengers | Killed | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 1.00 | 4.00 | 0.00 |
| Bus & coach Passengers | KSI | 5.06 | 1.62 | 6.14 | 11.53 | 1.28 | 2.97 | 5.23 | 16.51 | 15.57 | 30.65 | 24.33 | 41.04 | 58.44 | 82.59 | 75.09 | 13.72 |
| Goods vehicle Drivers | Killed | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 8.00 | 2.00 | 6.00 | 9.00 | 12.00 | 6.00 | 2.00 | 0.00 | 0.00 |
| Goods vehicle Drivers | KSI | 0.00 | 0.00 | 0.00 | 0.04 | 0.11 | 0.29 | 4.80 | 53.12 | 49.23 | 112.80 | 140.35 | 139.42 | 50.69 | 11.99 | 2.57 | 3.29 |
| Goods vehicle Passengers | Killed | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 2.00 | 4.00 | 1.00 | 1.00 | 2.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Goods vehicle Passengers | KSI | 1.36 | 1.54 | 1.22 | 2.91 | 1.17 | 1.40 | 7.86 | 30.82 | 13.28 | 23.42 | 26.44 | 14.86 | 3.67 | 1.37 | 0.35 | 4.47 |
| Other vehicle/Unknown vehicle occupants | Killed | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 1.00 | 0.00 | 2.00 | 5.00 | 2.00 | 5.00 | 5.00 | 0.00 |
| Other vehicle/Unknown vehicle occupants | KSI | 1.14 | 0.03 | 1.88 | 5.71 | 1.19 | 6.36 | 15.07 | 15.29 | 22.05 | 37.54 | 38.01 | 30.28 | 26.78 | 25.25 | 32.10 | 2.39 |
| All road users | Killed | 10.00 | 6.00 | 10.00 | 22.00 | 17.00 | 20.00 | 110.00 | 225.00 | 165.00 | 202.00 | 254.00 | 213.00 | 131.00 | 155.00 | 173.00 | 0.00 |
| All road users | KSI | 347.76 | 389.63 | 722.99 | 1021.82 | 454.42 | 754.60 | 1681.29 | 3686.42 | 2752.31 | 4044.53 | 4359.14 | 3393.01 | 2142.78 | 1556.42 | 1274.67 | 311.22 |
<tbody>
</tbody>
