topic Re: What is the best way to create a table applicable to the time slider for ArcMap in Public Safety Questions https://community.esri.com/t5/public-safety-questions/what-is-the-best-way-to-create-a-table-applicable/m-p/206217#M270 <HTML><HEAD></HEAD><BODY><P>Bret,</P><P></P><P>I'm not sure what you mean by "join sheets organized by the day", so let me know if my answer does not fit with what you're trying to do.</P><P></P><P>When you set the time properties for a layer, if will ask you if your data has a start time field or both start and end fields.&nbsp; You then go on to specify the interval you want ArcMap to step through the time field(s).&nbsp; So I believe the answer would be that you should combine all of your case data into one table, making sure the date fields are truly designated as type = date.&nbsp; ArcMap should be able to then help you visualize the data however you want over time (days, hours, minutes, etc...)</P><P></P><P>-Matt</P></BODY></HTML> Thu, 26 Mar 2020 13:58:13 GMT MattKennedy 2020-03-26T13:58:13Z What is the best way to create a table applicable to the time slider for ArcMap https://community.esri.com/t5/public-safety-questions/what-is-the-best-way-to-create-a-table-applicable/m-p/206216#M269 <HTML><HEAD></HEAD><BODY><P>I am tracking COVID here in my town and state (Ohio). What is the best way to lay out the data table to be applicable to the time slider?&nbsp; Should I join sheets organized by the day?</P></BODY></HTML> Mon, 23 Mar 2020 21:02:28 GMT https://community.esri.com/t5/public-safety-questions/what-is-the-best-way-to-create-a-table-applicable/m-p/206216#M269 BretSchoening 2020-03-23T21:02:28Z Re: What is the best way to create a table applicable to the time slider for ArcMap https://community.esri.com/t5/public-safety-questions/what-is-the-best-way-to-create-a-table-applicable/m-p/206217#M270 <HTML><HEAD></HEAD><BODY><P>Bret,</P><P></P><P>I'm not sure what you mean by "join sheets organized by the day", so let me know if my answer does not fit with what you're trying to do.</P><P></P><P>When you set the time properties for a layer, if will ask you if your data has a start time field or both start and end fields.&nbsp; You then go on to specify the interval you want ArcMap to step through the time field(s).&nbsp; So I believe the answer would be that you should combine all of your case data into one table, making sure the date fields are truly designated as type = date.&nbsp; ArcMap should be able to then help you visualize the data however you want over time (days, hours, minutes, etc...)</P><P></P><P>-Matt</P></BODY></HTML> Thu, 26 Mar 2020 13:58:13 GMT https://community.esri.com/t5/public-safety-questions/what-is-the-best-way-to-create-a-table-applicable/m-p/206217#M270 MattKennedy 2020-03-26T13:58:13Z