Card Pairings
Fuel Type
Fuel Prices
Transactions
6
0001424878448694
12
0008225324380890
15
0009166248651843
18
0017797313769068
24
0033096326196367
26
0050107203276372
32
0077754191644447
35
0084424274516903
39
0149927725053127
40
0173125226916013
41
0185553635533470
43
0186691126704685
44
0251477518051928
47
0444888335884258
49
0486485720241563
50
0634563546838416
52
0642512740106488
53
0651379375753384
54
0703368638009666
55
0814487286605687
56
0871757579646457
57
0955842181343612
58
1165791981725646
59
1593617996165345
62
1791759332109289
63
2052457862868733
66
2184430214515754
67
2343707230321271
68
2351772574466967
69
2872975641851317
70
3001771555642829
71
3274824635232551
72
3487399023971964
73
3681763762522500
74
3863576896894959
75
4444607387168101
78
4453890346891247
79
4551108946472022
82
4579323789024461
83
4606704884617470
84
4725218665812474
85
4987815395411850
87
5084493177386431
90
5192450694901179
91
5226957587751530
96
5282860928265596
97
5469328985781066
98
5730316697454595
100
6204753376934756
102
6234104517005484
103
6251963399796255
104
6267868190937507
107
7279873795746083
108
7457904464422969
112
7756493893196676
117
7907345435269574
119
8193120958099742
123
8246393146253933
124
8344190579338434
125
8370399840876032
126
8412270250622072
127
9033998253796525
128
9054937372368794
133
9543640566075967
138
9603184265166798
141
9855392114361673
0-99
Diesel
25.0
100-999
Gas
33.0
2021-01-01
2.16
2.33
2021-01-02
2.18
2.33
2021-01-03
2.18
2.34
2021-01-04
2.26
2.36
2021-01-05
2.25
2.38
2021-01-06
2.24
2.41
2021-01-07
2.24
2.40
2021-01-08
2.27
2.40
2021-01-09
2.27
2.38
2021-01-10
2.28
2.36
2021-01-11
2.28
2.34
2021-01-12
2.31
2.34
2021-01-13
2.33
2.38
2021-01-14
2.35
2.42
2021-01-15
2.36
2.46
2021-01-16
2.34
2.48
2021-01-17
2.31
2.49
2021-01-18
2.27
2.49
2021-01-19
2.27
2.45
2021-01-20
2.29
2.44
2021-01-21
2.31
2.44
2021-01-22
2.31
2.43
2021-01-23
2.33
2.42
2021-01-24
2.34
2.45
2021-01-25
2.35
2.47
2021-01-26
2.35
2.47
2021-01-27
2.36
2.49
2021-01-28
2.36
2.48
2021-01-29
2.38
2.51
2021-01-30
2.34
2.50
2021-01-31
2.35
2.50
2021-02-01
2.36
2.46
2021-02-02
2.36
2.45
2021-02-03
2.31
2.45
2021-02-04
2.28
2.48
2021-02-05
2.29
2.50
2021-02-06
2.32
2.52
2021-02-07
2.33
2.53
2021-02-08
2.35
2.53
2021-02-09
2.38
2.55
2021-02-10
2.39
2.55
2021-02-11
2.41
2.53
2021-02-12
2.41
2.55
2021-02-13
2.42
2.55
2021-02-14
2.43
2.56
2021-02-15
2.44
2.58
2021-02-16
2.45
2.56
2021-02-17
2.44
2.57
2021-02-18
2.46
2.58
2021-02-19
2.48
2.59
2021-02-20
2.48
2.61
2021-02-21
2.50
2.63
2021-02-22
2.52
2.64
2021-02-23
2.53
2.66
2021-02-24
2.55
2.68
2021-02-25
2.58
2.71
2021-02-26
2.53
2.70
2021-02-27
2.50
2.66
2021-02-28
2.48
2.65
0008225324380890
2021-02-06
49.93
0009166248651843
2021-01-24
32.8
0017797313769068
2021-01-05
66.45
0017797313769068
2021-01-15
49.24
0050107203276372
2021-01-08
25.84
0050107203276372
2021-01-12
48.57
0077754191644447
2021-02-27
54.8
0084424274516903
2021-01-27
49.29
0149927725053127
2021-01-22
39.57
0173125226916013
2021-02-19
28.71
0185553635533470
2021-02-23
47.42
0186691126704685
2021-02-04
39.25
0251477518051928
2021-01-25
52.88
0642512740106488
2021-02-08
37.5
0703368638009666
2021-02-12
62.81
0814487286605687
2021-01-07
51.8
0814487286605687
2021-01-13
63.85
0871757579646457
2021-02-15
30.34
1165791981725646
2021-02-24
56.23
2052457862868733
2021-01-23
31.75
2184430214515754
2021-02-22
38.55
2343707230321271
2021-02-16
32.54
2351772574466967
2021-02-07
41.39
2872975641851317
2021-02-17
42.9
3001771555642829
2021-02-25
57.78
3274824635232551
2021-01-06
36.43
3274824635232551
2021-01-14
44.96
3487399023971964
2021-02-05
26.1
3681763762522500
2021-02-28
50.64
3863576896894959
2021-01-02
49.44
3863576896894959
2021-01-18
45.47
4444607387168101
2021-02-01
54.45
4725218665812474
2021-01-09
43.55
4725218665812474
2021-01-11
47.19
4987815395411850
2021-02-13
67.26
5084493177386431
2021-02-20
50.7
5192450694901179
2021-02-18
33.54
5730316697454595
2021-01-29
27.1
6204753376934756
2021-01-28
52
6234104517005484
2021-01-26
56.24
6251963399796255
2021-01-01
66.48
6251963399796255
2021-01-19
68.82
6267868190937507
2021-02-02
53.54
7279873795746083
2021-01-31
67.75
7457904464422969
2021-02-14
56.43
7756493893196676
2021-01-21
43.84
7907345435269574
2021-01-04
50.36
7907345435269574
2021-01-16
67.76
8193120958099742
2021-01-03
68.37
8193120958099742
2021-01-17
60.33
8246393146253933
2021-02-26
45.34
8344190579338434
2021-01-20
71.76
8370399840876032
2021-02-11
45.51
8412270250622072
2021-02-09
51.75
9033998253796525
2021-01-30
56.97
9054937372368794
2021-02-21
50.34
9603184265166798
2021-02-03
53.45
9855392114361673
2021-02-10
48.35
Type = IF [Van Number] <= 99 THEN 'Diesel' ELSE 'Gas' ENDIF
Capacity = IIF([Type...
Total Amount = IF [Type] = 'Gas' THEN [Capacity]*[Regular] ELSE [Capacity]*[Dies...
[Total Amount] <= [Amount]
Custom
[Total Amount] <= [Amount]
Percent = ([Amount]*100)/[Total Amount]
Flag = IF [Percent] >= 90 THEN "2" ELSE ...
Simple
=
Flag
True
fixed
2022-07-12 15:50:58
0
2
2022-07-12 15:50:58
2022-07-12 15:50:58
[Flag] = "2"
Percent = ([Amount]*100)/[Total Amount]
Flag = IF [Percent] >= 90 THEN "1" else ...
Simple
>=
Percent
True
fixed
2022-07-13 08:08:43
0
90
2022-07-13 08:08:43
2022-07-13 08:08:43
[Percent] >= 90
Warning
All
ByName
Flag - Ascending
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.”
Horizontal
Solution 260