Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have data for vehicle registration and Movement count. I want to group these not by serial but by count.
e.g. "16" movement count - 2 vehicles , 2% of all movements
Thanks
HN51 CWM 17
GL52 XOO 16
OJ69 BVU 16
GS57 IGF 15
UX69 UMP 15
CM58 HNQ 15
PA66 BSA 13
RC63 IFF 13
LT61 TTK 13
KN57 GNM 13
QP68 ZVX 13
MI61 VJY 13
JX65 RKR 12
IT52 TZL 12
HV61 EDP 12
LS69 BBP 12
IU52 NAK 12
QV63 QYJ 12
CO67 UNO 12
BO58 HGZ 12
TN59 ZPF 12
TE53 SJV 11
TA69 VME 11
HY52 PIQ 11
WY69 OCK 11
DO63 PRF 11
EU64 IBZ 11
DF53 QNT 11
NC64 MUY 11
AU61 LAP 11
LF55 OFF 11
FM59 MIE 11
XR67 KPE 11
OA68 YZL 11
KS67 PMK 11
XU67 BGD 10
MM66 BRN 10
BJ65 IKA 10
EN61 TKZ 10
KZ67 WWW 10
QO56 RGF 10
FP65 XNX 10
IO67 MIF 10
LY66 IXU 10
IE52 PPF 10
CW62 VFU 10
CS64 JBX 10
TP63 IJU 10
JF66 VAI 10
YC63 IAJ 10
JV57 ENE 10
VQ59 QEG 10
FC67 VNJ 10
AI59 OXR 10
MU53 BER 10
HK62 ZNX 10
TF66 VPB 10
YN69 ONF 10
ET67 CTQ 10
EM55 ADB 10
JR62 ZMN 10
SG67 JUF 10
AY52 PJP 10
YI67 SSD 10
QX66 VZB 10
LG61 YVH 10
UJ62 FEF 10
SR61 IGU 10
IK66 ZOO 10
VY51 APV 10
CJ57 VHH 10
GY68 RLR 10
DY59 OBI 10
AH56 HTY 10
CU56 PVL 10
IG54 CAV 10
JK63 DRH 10
EL61 HMK 10
ID62 UOF 9
JK52 RLD 9
MR51 FAE 9
MK58 PFK 9
YK62 YAX 9
PJ67 NCN 9
OQ64 GGN 9
HH58 ZHK 9
FL61 NFX 9
AP53 XLK 9
PC61 VRM 9
JO55 YJD 9
ST53 XRN 9
AF53 GYI 9
BQ56 BZF 9
YC62 HMJ 9
TQ53 ZZV 9
NQ54 MXL 9
CJ62 MIL 9
LC51 XRD 9
GY63 UGO 9
GK53 SIL 9
OT56 KDH 9
KA53 SKT 9
YJ59 CXB 9
AG67 AKP 9
VE58 KOX 9
NN54 DRZ 9
AO67 QZL 9
VK56 SBM 9
This script should do it.
BASE:
LOAD * INLINE [
ID, VEHICLE, COUNT
HN51, CWM, 17
GL52, XOO, 16
OJ69, BVU, 16
GS57, IGF, 15
UX69, UMP, 15
];
AGG_BASE:
Load COUNT,
COUNT(VEHICLE) as AMOUNT_PER_COUNT
Resident BASE
GROUP BY COUNT
;
This script should do it.
BASE:
LOAD * INLINE [
ID, VEHICLE, COUNT
HN51, CWM, 17
GL52, XOO, 16
OJ69, BVU, 16
GS57, IGF, 15
UX69, UMP, 15
];
AGG_BASE:
Load COUNT,
COUNT(VEHICLE) as AMOUNT_PER_COUNT
Resident BASE
GROUP BY COUNT
;