cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

ESRI ArcGIS Visualization Time Field

I'm using the ESRI ArcGIS visualization, and it's pretty neat! I love the fact that it has a time field, which is great to show how data plays out over time. My problem is that my data has a Start Date/Time and an End Date/Time. How do I create some sort of 'Active Date/Time"? 

 

Basically if something starts at 7AM, and ends at 10AM, I would want that point to be displaying for hours 7, 8, 9, and 10 AM but to disappear afterwards. Currently it is only showing me data based on the single start date/time field, so it will only show it at 7AM and then it immediately disappears.

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: ESRI ArcGIS Visualization Time Field

Hi @soldstatic,

 

Can you share a sample? Maybe you need a measure. Or you need to change the data structure.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Resolver I
Resolver I

Re: ESRI ArcGIS Visualization Time Field

Sure the data looks like this (anonymized for the forum):

 

IDStart DateEnd DateStatusComp1LengthComp2CLatitudeLongitude
543571155/1/18 0:015/1/18 0:13CMP4712.41666667583.5833331914XY
543571165/1/18 0:095/1/18 0:13CNL14.654.651263XY
543571175/1/18 0:285/1/18 0:32CNL14.854.851263XY
543571185/1/18 1:045/1/18 15:25CMP0860.416666705332XY
543571195/1/18 1:265/1/18 1:33CNL17.2166666677.216666679141XY
543571205/1/18 1:385/1/18 1:59CNL121.3333333321.33333331263XY
543571215/1/18 1:555/1/18 1:59CNL14.3333333334.333333339141XY
543571225/1/18 2:145/1/18 2:37CNL123.923.91263XY
543571235/1/18 2:405/1/18 2:59CNL119.7166666719.716666712834XY
543571245/1/18 2:405/1/18 4:07CMP15087.4166666713112.512834XY
543571255/1/18 2:475/1/18 2:59CNL112.912.91263XY
543571265/1/18 2:535/1/18 3:00CNL16.76.7UNKNOWNXY

 

This is just a sample but events are about two hours long, but it varies drastically. I'd like this to look like one of those weather gifs where the animation plays out the series of events over time, but it currently only shows the data during the time frame when the events begin. It doesn't take into account the time that the events are restored.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors