Spreadsheet: 777462d1650392824-counting-distinct-values-within-a-date-range-feeod-sample
Sheet: report creating sheet

total visit count | FE Visits | Actual revisits | FE Visits in April | Visit Status | issues type | issue resonsible | issue count | Region | Market | Site ID | Field Engineer | Entered in | Entered in [Checked-out] | Visit type | Integration Complete | Issues/Pending | Issues/Pending Reasons | Router [NAME] | Router Port 39 speed | Router Port 40 speed | [NAME] | Nokia 5G SW Push | [NAME] push | Nokia 5G SCF push | Nokia LTE Certificate added | Nokia 5G Certificate added | [NAME] testing | LTE Data testing | 5G Data testing | [NAME] | [NAME] | Nokia 5G Connectivity | BBU Serial Number | BBU Asset Tag | [NAME] Number | [NAME] tag | Nokia 5G ASIB Serial Number | Nokia 5G ASIB Asset tag | [NAME] Asset tag | ABIA Asset tag | Pico/DAS installed | Speed Test Result
 |  |  |  |  |  |  |  | Region | Market | Site ID | Field Engineer | Entered in | Entered in [Checked-out] | Visit type | Integration Complete | Issues/Pending | Issues/Pending Reasons | Router [NAME] | Router Port 39 speed | Router Port 40 speed | [NAME] | Nokia 5G SW Push | [NAME] push | Nokia 5G SCF push | Nokia LTE Certificate added | Nokia 5G Certificate added | [NAME] testing | LTE Data testing | 5G Data testing | [NAME] | [NAME] | Nokia 5G Connectivity | BBU Serial Number | BBU Asset Tag | [NAME] Number | [NAME] tag | Nokia 5G ASIB Serial Number | Nokia 5G ASIB Asset tag | [NAME] Asset tag | ABIA Asset tag | Pico/DAS installed | Speed Test Result | Speed Test Result
 |  |  |  |  |  |  |  | West | CA | VGY6601A | [NAME] | 2022-04-01 00:00:00 | 2022-04-01 13:44:41 | Call and Data testing | No | Transport | LOW SPEED BELOW 100MBPS. NOC EMAIL RECEIVED PENDING MIGRATION | Yes | 97.45/37 | 91.66/37.07 | No | No | No | No | No | No | No | No | No | Yes | No | No | E23C123136 |  |  |  |  |  |  |  | Yes | 11670595 | 11670595
 |  |  |  |  |  |  |  | NE | DC | DC1097Z | [NAME] | 2022-04-01 00:00:00 | 2022-04-01 18:30:15 | Call and Data testing | Yes | No issue/pending |  | Yes | 926.76DL 41.73UL | 920.34DL 41.90UL | No | No | No | No | No | No | Yes | Yes | Yes | Yes | No | No |  |  |  |  |  |  |  |  | No | 11670040,11670041,11670042,11670043,11670044,11670045,11670046,11670047,11670048,11670049,11670050,11670051,11670052,11670053,11670054,11670055,11670056,11670057,11670058,11670059,11670060,11670061,11670062,11670063,11670064,11670065,11670066 | 11670040,11670041,11670042,11670043,11670044,11670045,11670046,11670047,11670048,11670049,11670050,11670051,11670052,11670053,11670054,11670055,11670056,11670057,11670058,11670059,11670060,11670061,11670062,11670063,11670064,11670065,11670066
 |  |  |  |  |  |  |  | NE | DC | DC1067Z | [NAME] | 2022-04-01 00:00:00 | 2022-04-01 19:04:57 | Call and Data testing | No | No issue/pending |  | Yes | 704.10DL 7.11UL | 646.39DL 10.43UL | No | No | No | No | No | No | Yes | Yes | Yes | No | No | No |  |  |  |  |  |  |  |  | No | 11676438,11676439,11676440,11676441,11676442,11676443,11676444,11676445,11676446,11676447,11676448,11676449,11676450,11676451,11676452,11676453,11676454,11676455,11676456,11676457,11676458,11676459,11676460,11676461,11676462,11676463,11676464,11676465,11676466 | 11676438,11676439,11676440,11676441,11676442,11676443,11676444,11676445,11676446,11676447,11676448,11676449,11676450,11676451,11676452,11676453,11676454,11676455,11676456,11676457,11676458,11676459,11676460,11676461,11676462,11676463,11676464,11676465,11676466
 |  |  |  |  |  |  |  | NE | NJ | NJ0048Z | [NAME] | 2022-04-04 00:00:00 |  | Call and Data testing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (blank)
 |  |  |  |  |  |  |  | West | CA | SVY5014A | [NAME] | 2022-04-04 00:00:00 | 2022-04-04 12:34:16 | Call and Data testing | No | No issue/pending |  | No |  |  | No | No | No | No | No | No | No | Yes | Yes | Yes | No | No | E23C749977 |  |  |  |  |  |  |  | No | 11705120,11705129 | 11705120,11705129
 |  |  |  |  |  |  |  | Central | DN | DN0063WA | [NAME] | 2022-04-04 00:00:00 | 2022-04-04 18:19:37 | Integration | Yes | No issue/pending |  | Yes | 165.75/99.21 | 181.68/164.44 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes |  |  | K9214805945 | TM10373573 | K9214805909 | TM10373574 | TM10275364 | TM10496884 | Yes | 11712655,11712656,11712657,11712658,11712659,11712660,11712661,11712662,11712663,11712664,11712665,11712666,11712667,11712668,11712669,11712670,11712671,11712672,11712673,11712674 | 11712655,11712656,11712657,11712658,11712659,11712660,11712661,11712662,11712663,11712664,11712665,11712666,11712667,11712668,11712669,11712670,11712671,11712672,11712673,11712674
 |  |  |  |  |  |  |  | West | CA | [NAME] | [NAME] | 2022-04-05 00:00:00 | 2022-04-05 12:29:54 | Call and Data testing | No | No issue/pending |  | No |  |  | No | No | No | No | No | No | Yes | Yes | Yes | Yes | No | No | E23C268710 |  |  |  |  |  |  |  | No | 11729894,11729947 | 11729894,11729947
 |  |  |  |  |  |  |  | NE | PH | PH0113Z | [NAME] | 2022-04-05 00:00:00 | 2022-04-05 16:13:43 | Integration | Yes | No issue/pending |  | Yes | 506.13DL 41.01UL | 491.98DL 15.35UL | No | No | No | No | No | No | Yes | Yes | Yes | No | No | No |  |  |  |  |  |  |  |  | No | 11730883,11730884,11730885,11730886,11730887,11730888,11730889,11730890,11730891,11730892,11730893,11730894,11730895,11730896,11730897,11730898,11730899,11730900,11730901,11730902,11730903,11730904,11730905,11730906,11730907,11730908,11730909 | 11730883,11730884,11730885,11730886,11730887,11730888,11730889,11730890,11730891,11730892,11730893,11730894,11730895,11730896,11730897,11730898,11730899,11730900,11730901,11730902,11730903,11730904,11730905,11730906,11730907,11730908,11730909
 |  |  |  |  |  |  |  | West | SF | SFYL101A | [NAME] | 2022-04-05 00:00:00 | 2022-04-05 19:11:57 | Integration | Yes | Other | Low router speeds | Yes | 228.46 | 228.41 | No | No | No | No | No | No | No | No | No | Yes | No | No |  |  |  |  |  |  |  |  | No | 11739829,11739849 | 11739829,11739849
 |  |  |  |  |  |  |  | Central | WI | WI1625WA | [NAME] | 2022-04-05 00:00:00 | 2022-04-05 18:32:16 | Integration | No | No issue/pending |  | No | 104.99/95.28 |  | No | No | No | No | No | No | Yes | Yes | No | No | No | No |  |  |  |  |  |  |  |  | Yes | 11734234,11736340,11736341,11736342,11736343,11736344,11736345,11736351,11736352,11736353,11736354,11736355,11736356,11736357,11736358 | 11734234,11736340,11736341,11736342,11736343,11736344,11736345,11736351,11736352,11736353,11736354,11736355,11736356,11736357,11736358
 |  |  |  |  |  |  |  | NE | NY | NY0091Z | [NAME] | 2022-04-06 00:00:00 | 2022-04-06 11:38:07 | Call and Data testing | No | No issue/pending | Wrong site check in | No |  |  | No | No | No | No | No | No | No | No | No | No | No | No |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | NE | NY | NY0091WA | [NAME] | 2022-04-06 00:00:00 |  | Call and Data testing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (blank)
 |  |  |  |  |  |  |  | West | SF | SFY5042A | [NAME] | 2022-04-06 00:00:00 | 2022-04-06 16:43:24 | Integration | No | No issue/pending |  | No |  |  | No | No | No | No | No | No | No | Yes | Yes | Yes | No | No | E23C886847 |  |  |  |  |  |  |  | No | 11764709,11764710,11764713,11764714,11764715 | 11764709,11764710,11764713,11764714,11764715
 |  |  |  |  |  |  |  | West | CA | IEY5007A | [NAME] | 2022-04-06 00:00:00 | 2022-04-06 14:01:01 | Call and Data testing | No | Transport | LOW PORT BH SPEEDS AT 150MBPS. PRIMARY ISP ROUTER G_0_00 ALSO SHOWS ONLY 45MBPS | Yes | 154.42/95.90 | 150.01/93.16 | No | No | No | No | No | No | No | No | No | No | No | No | E23C632570 |  |  |  |  |  |  |  | No | 11759797 | 11759797
 |  |  |  |  |  |  |  | West | PHX | PXY8201A | Monzur Islam | 2022-04-06 00:00:00 | 2022-04-06 15:14:27 | Call and Data testing | Yes | No issue/pending |  | Yes |  |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |  |  |  |  |  |  |  |  | No | 11762112 | 11762112
 |  |  |  |  |  |  |  | South | HN | HNYL801A | [NAME] | 2022-04-06 00:00:00 | 2022-04-06 22:40:50 | Call and Data testing | Yes | Other |  | Yes | 459.84  UL 188.92 | 378.05  UL 144.48 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes |  |  | DH213530424 | TM10294078 | DH213530323 | TM10433785 | DH213330148 | TM10279505 | Yes | 11769264,11769265,11769266,11769267,11769268,11769269,11769270,11769271,11769272,11769273,11769274,11769275,11769276,11769277,11769278,11769279,11769280,11769281,11769282,11769283 | 11769264,11769265,11769266,11769267,11769268,11769269,11769270,11769271,11769272,11769273,11769274,11769275,11769276,11769277,11769278,11769279,11769280,11769281,11769282,11769283
 |  |  |  |  |  |  |  | NE | NY | BX0004Z | [NAME] | 2022-04-07 00:00:00 | 2022-04-07 15:03:52 | Integration | Yes | No issue/pending |  | No | DL 482.59     UL 21.03 | DL 479.15   UL  22.47 | No | No | No | No | No | No | Yes | Yes | Yes | Yes | No | No | E23D483966 |  |  |  |  |  |  |  | No | 11784473 | 11784473
 |  |  |  |  |  |  |  | West | CA | [NAME] | [NAME] | 2022-04-08 00:00:00 | 2022-04-08 08:11:51 | Call and Data testing | No | Access | Store did not approve MW activity. Site cancelled. | No |  |  | No | No | No | No | No | No | No | No | No | No | No | No |  |  |  |  |  |  |  |  | No | 11807183 | 11807183
 |  |  |  |  |  |  |  | South | HN | HNYJ401A | [NAME] | 2022-04-07 00:00:00 | 2022-04-07 17:30:42 | Call and Data testing | Yes | DOT/Antenna | antennas are not powered up | No | 357.74   ul 41.66 | 433.11  ul  41.62 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes |  |  | DH2119666656 | TM10145396 | TM10145396 | DH211966667 | DH212860897 | DH213081044 | Yes | 11788345,11788346,11788347,11788348,11788349,11788350,11788351,11788352,11788353,11788354,11788355,11788356,11788357,11788358,11788359,11788360,11788361,11788362,11788363,11788364 | 11788345,11788346,11788347,11788348,11788349,11788350,11788351,11788352,11788353,11788354,11788355,11788356,11788357,11788358,11788359,11788360,11788361,11788362,11788363,11788364
 |  |  |  |  |  |  |  | Central | SL | SL0607WA | [NAME] | 2022-04-07 00:00:00 | 2022-04-07 18:33:04 | Integration | No | Other | Slow CCT/Wrong SCF | No | 4.46/6.20 |  | No | No | Yes | No | Yes | No | No | No | No | No | No | No |  |  |  |  |  |  |  |  | Yes | 11793165 | 11793165
 |  |  |  |  |  |  |  | West | SF | SFYL601A | [NAME] | 2022-04-07 00:00:00 | 2022-04-08 00:41:08 | Integration | No | DOT/Antenna |  | Yes | 926.59 | 924.52 | No | No | No | No | No | No | No | No | Yes | No | No | No | E23C159392 |  |  |  |  |  |  |  | No | 11798730,11798731,11798732,11798758,11798759 | 11798730,11798731,11798732,11798758,11798759
 |  |  |  |  |  |  |  | NE | NY | BX0022WA | [NAME] | 2022-04-08 00:00:00 | 2022-04-08 18:39:09 | Integration | Yes | No issue/pending |  | Yes | DL 778.60  UL 45.33 | DL 730.78  UL 52.02 | No | No | No | No | No | No | Yes | Yes | Yes | Yes | No | No | E23D275198 |  |  |  |  |  |  |  | No | 11818509,11818510,11818511,11818512,11818513,11818514,11818515,11818516,11818517,11818522,11818523,11818524,11818525,11818526,11818527,11818528,11818529,11818530,11818531,11818532,11818533,11818534,11818535,11818536,11818537,11818538,11818539 | 11818509,11818510,11818511,11818512,11818513,11818514,11818515,11818516,11818517,11818522,11818523,11818524,11818525,11818526,11818527,11818528,11818529,11818530,11818531,11818532,11818533,11818534,11818535,11818536,11818537,11818538,11818539
 |  |  |  |  |  |  |  | NE | PH | PH0124Z | [NAME] | 2022-04-08 00:00:00 | 2022-04-08 16:08:36 | Integration | Yes | No issue/pending |  | Yes | 334.32DL 41.09UL | 377.07DL 41.92UL | No | No | No | No | No | No | Yes | Yes | Yes | Yes | No | No |  |  |  |  |  |  |  |  | No | 11814005,11814008,11814009,11814010,11814011,11814012,11814013,11814014,11814015,11814016,11814017,11814018,11814019,11814020,11814021,11814022,11814023,11814024,11814025,11814026,11814027,11814028,11814029,11814030,11814031,11814032,11814033,11814034 | 11814005,11814008,11814009,11814010,11814011,11814012,11814013,11814014,11814015,11814016,11814017,11814018,11814019,11814020,11814021,11814022,11814023,11814024,11814025,11814026,11814027,11814028,11814029,11814030,11814031,11814032,11814033,11814034
 |  |  |  |  |  |  |  | Central | SL | SL0607WA | [NAME] | 2022-04-08 00:00:00 | 2022-04-08 14:47:10 | Call and Data testing | No | No issue/pending |  | No |  | 4.46/6.20 | No | No | No | No | No | No | No | No | No | No | No | No |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  | West | SF | SFY5060A | [NAME] | 2022-04-11 00:00:00 | 2022-04-11 18:26:41 | Integration | Yes | DOT/Antenna | NR DOT fluctuating | Yes |  | 930/901 | No | No | No | No | No | No | Yes | Yes | No | Yes | No | No | E23C847052 |  |  |  |  |  |  |  | No | 11856545,11856546,11856547,11856548 | 11856545,11856546,11856547,11856548
 |  |  |  |  |  |  |  | NE | PH | PH0114Z | [NAME] | 2022-04-12 00:00:00 | 2022-04-12 16:07:11 | Integration | Yes | No issue/pending |  | Yes |  | DL 902.27 UL 33.78 | No | No | No | No | No | No | Yes | Yes | Yes | No | No | No | E23D506147 |  |  |  |  |  |  |  | No | 11874476,11874477,11874478,11874479,11874480,11874481,11874482,11874483,11874484,11874485,11874486,11874487,11874488,11874489,11874490,11874492,11874493,11874494,11874500,11874501,11874502,11874503,11874504,11874505,11874506,11874507,11874508 | 11874476,11874477,11874478,11874479,11874480,11874481,11874482,11874483,11874484,11874485,11874486,11874487,11874488,11874489,11874490,11874492,11874493,11874494,11874500,11874501,11874502,11874503,11874504,11874505,11874506,11874507,11874508
 |  |  |  |  |  |  |  | Central | OK | TU1624WA | [NAME] | 2022-04-12 00:00:00 | 2022-04-12 19:08:34 | Call and Data testing | Yes | No issue/pending |  | Yes | 101.29/95.49 | 102.83/95.56 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes |  |  | DH213850592 | TM104609911 | DH213850498 | TM10460827 | TM10157808 | TM10440779 | No | 11881237,11881238,11881239,11881240,11881241,11881242,11881243,11881244,11881245,11881246,11881252,11881253,11881254,11881255,11881256,11881257,11881258,11881259,11881260 | 11881237,11881238,11881239,11881240,11881241,11881242,11881243,11881244,11881245,11881246,11881252,11881253,11881254,11881255,11881256,11881257,11881258,11881259,11881260
 |  |  |  |  |  |  |  | West | SE | SEY6701A | Monzur Islam | 2022-04-12 00:00:00 | 2022-04-12 14:33:48 | Call and Data testing | Yes | No issue/pending |  | Yes |  |  | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes |  |  |  |  |  |  |  |  | Yes | 11876624 | 11876624
 |  |  |  |  |  |  |  | NE | NJ | NJ0045Z | [NAME] | 44664 | 2022-04-13 17:27:49 | Integration | No | Other | Carrier frequency out of band alarm | No | DL 917.51 UL 41.99 | DL 926.92 UL 41.99 | No | No | No | No | No | No | No | No | No | No | No | No | EA2A411405 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | Central | CHI | CH0077WA | [NAME] | 2022-04-13 00:00:00 | 2022-04-13 16:58:32 | Call and Data testing | No | Other |  | No |  |  | No | No | No | No | No | No | No | No | No | No | No | No |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | Central | CHI | SL0221WA | [NAME] | 2022-04-13 00:00:00 | 2022-04-14 01:59:08 | Integration | No | Transport | Circuit is down | No |  |  | No | No | No | No | No | No | No | No | No | No | No | No |  |  | [NAME] | TM10379818 | [NAME] | TM10379816 | TM10382713 | TM09704187 | No
 |  |  |  |  |  |  |  | NE | VA | VA1066Z | [NAME] | 44665 |  | Integration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (blank)
 |  |  |  |  |  |  |  | Central | SL | SL0215WA | [NAME] | 2022-04-14 00:00:00 | 2022-04-14 14:27:42 | Integration | No | No issue/pending |  | No |  | 247.30/52.63 | No | No | No | No | No | No | No | No | No | No | No | No |  |  |  |  |  |  |  |  | Yes | 11929095,11929096,11929097,11929098,11929099,11929100,11929101,11929102,11929103,11929107,11929108,11929109,11929110,11929111,11929112 | 11929095,11929096,11929097,11929098,11929099,11929100,11929101,11929102,11929103,11929107,11929108,11929109,11929110,11929111,11929112
 |  |  |  |  |  |  |  | West | LAN | SVY5024A | [NAME] | 44665 |  | Call and Data testing | No |  |  | No |  |  | No | No | No | No | No | No | No | No | No | No | No | No |  |  |  |  |  |  |  |  | (blank) | 11932051 | 11932051