I have a list of data on when devices were added to my system. What I don't know is the total number of devices in the system at any given time. Say like monthly since the beginning. I have a unique identifier of each device if that matters as well beyond the date it was added. How would I take that data and chart growth from the first device added to the last? Basically looking at a line chart showing the upward trend over time of total devices in the system. Monthly bar charts showing monthly totals would be kind of cool also. Struggling with having a list of dates and how to use those to generate totals.
Below would be the data comma delimited since didn't see a way to upload a file:
Enrollment Date,Device Identifier
9/18/2018 10:23,GB88TF59EU49MA38SE20SZ29ZC60
10/5/2018 11:08,VJ59YD69RR98TA74KU47OV91DH35
10/5/2018 12:14,AE96UA26SJ28IC79FK49DJ70AK50
10/8/2018 8:23,LX21PS33TD72AJ18OH82PY94GH18
10/8/2018 12:23,EK24LW73MX35HD98TV64ZA63GK54
10/8/2018 12:48,DL81OR92GD69YK62IN84UP91NH67
10/8/2018 13:09,WI32QD62QK71JS19XU19VD42VK22
10/8/2018 13:10,BD64JX35QO89OU24WZ84AY15HE31
10/8/2018 14:36,VV68UI62XU32MJ16IK96LS67SE67
10/8/2018 14:45,QR41UN30GE76IX25PI52AY54FE85
10/9/2018 11:00,MF52FW82UX14RS97CV88JS46SU62
10/9/2018 11:11,GG48XW84LR23AC64PL47TZ93DY69
10/9/2018 11:36,MB69JM75ID58SS23XQ92LR11RF58
11/1/2018 11:39,FO22WP80JM52FZ10CS80CG70JS74
11/19/2018 16:13,AJ76SZ37MA44KJ47BV85SP87FC76
1/14/2019 12:18,XG92GS42ID91RB37YL70NR54WM56
1/14/2019 12:12,MI17LH23AW40GT46XC74MH76VE61
1/7/2019 11:14,NJ64YX77DI75MF27KA39QL89PG74
1/4/2019 12:05,OJ37FY73OS78BX72OD10QN84AF66
1/10/2019 10:03,YB22YF67OE97QC61UB94FW40ZG59
1/10/2019 10:13,MQ17VP19NG37CR31ET65AD49UR30
1/10/2019 10:19,WZ80HI12JU74SE48IV42BQ73UV63
1/10/2019 10:21,UU94HP20ZI94SP99WG44DZ22HO50
1/15/2019 10:26,PM86IA38SJ87PK10FF95GM15GA76
1/15/2019 10:34,TY17WM40WS60YA61WY69HS85YE67
1/15/2019 10:44,GH87MV12JN59KI15SA22HD45ND93
1/15/2019 14:08,IX60XN84MC18JU67AB37PT80GR51
3/4/2019 10:52,EQ52GN11TV77HX13ZM78VN86RE81
1/17/2019 11:32,MI13MK52YS15HZ21MJ48AH10LU85
1/17/2019 13:07,VU62GF53CZ62WO25YQ31AR88ZH89
1/18/2019 15:10,OU76SD36KC29LW56EF57HU23CV21
1/22/2019 12:59,QT71NG11AL77IE31BV62PY15EB27
1/22/2019 13:24,YU85TE88MQ50PC98BF42OG48IW22
1/23/2019 19:22,PI97RG17AL54BE60EH77UY35TJ37
1/23/2019 10:21,QU25EN91EJ88SU68CY55SZ88AQ49
1/23/2019 10:25,GC91FU93VZ87GF47YA70KI27SM96
Appreciate any insight.
Thanks.
JR
Below would be the data comma delimited since didn't see a way to upload a file:
Enrollment Date,Device Identifier
9/18/2018 10:23,GB88TF59EU49MA38SE20SZ29ZC60
10/5/2018 11:08,VJ59YD69RR98TA74KU47OV91DH35
10/5/2018 12:14,AE96UA26SJ28IC79FK49DJ70AK50
10/8/2018 8:23,LX21PS33TD72AJ18OH82PY94GH18
10/8/2018 12:23,EK24LW73MX35HD98TV64ZA63GK54
10/8/2018 12:48,DL81OR92GD69YK62IN84UP91NH67
10/8/2018 13:09,WI32QD62QK71JS19XU19VD42VK22
10/8/2018 13:10,BD64JX35QO89OU24WZ84AY15HE31
10/8/2018 14:36,VV68UI62XU32MJ16IK96LS67SE67
10/8/2018 14:45,QR41UN30GE76IX25PI52AY54FE85
10/9/2018 11:00,MF52FW82UX14RS97CV88JS46SU62
10/9/2018 11:11,GG48XW84LR23AC64PL47TZ93DY69
10/9/2018 11:36,MB69JM75ID58SS23XQ92LR11RF58
11/1/2018 11:39,FO22WP80JM52FZ10CS80CG70JS74
11/19/2018 16:13,AJ76SZ37MA44KJ47BV85SP87FC76
1/14/2019 12:18,XG92GS42ID91RB37YL70NR54WM56
1/14/2019 12:12,MI17LH23AW40GT46XC74MH76VE61
1/7/2019 11:14,NJ64YX77DI75MF27KA39QL89PG74
1/4/2019 12:05,OJ37FY73OS78BX72OD10QN84AF66
1/10/2019 10:03,YB22YF67OE97QC61UB94FW40ZG59
1/10/2019 10:13,MQ17VP19NG37CR31ET65AD49UR30
1/10/2019 10:19,WZ80HI12JU74SE48IV42BQ73UV63
1/10/2019 10:21,UU94HP20ZI94SP99WG44DZ22HO50
1/15/2019 10:26,PM86IA38SJ87PK10FF95GM15GA76
1/15/2019 10:34,TY17WM40WS60YA61WY69HS85YE67
1/15/2019 10:44,GH87MV12JN59KI15SA22HD45ND93
1/15/2019 14:08,IX60XN84MC18JU67AB37PT80GR51
3/4/2019 10:52,EQ52GN11TV77HX13ZM78VN86RE81
1/17/2019 11:32,MI13MK52YS15HZ21MJ48AH10LU85
1/17/2019 13:07,VU62GF53CZ62WO25YQ31AR88ZH89
1/18/2019 15:10,OU76SD36KC29LW56EF57HU23CV21
1/22/2019 12:59,QT71NG11AL77IE31BV62PY15EB27
1/22/2019 13:24,YU85TE88MQ50PC98BF42OG48IW22
1/23/2019 19:22,PI97RG17AL54BE60EH77UY35TJ37
1/23/2019 10:21,QU25EN91EJ88SU68CY55SZ88AQ49
1/23/2019 10:25,GC91FU93VZ87GF47YA70KI27SM96
Appreciate any insight.
Thanks.
JR