topic Re: Operation Dashboard - Fields w/ Date data types in ArcGIS Dashboards Questions

Operation Dashboard - Fields w/ Date data types

JordanMiller4 — Tue, 20 Feb 2018 19:50:32 GMT

I don't understand how fields w/ Date data types could possibly generate a time.. " ,7:00" time at the end. See the img below. We're using the Portal dashboard. How do I prevent a time from showing?

Re: Operation Dashboard - Fields w/ Date data types

DerekLaw — Sat, 03 Mar 2018 05:29:41 GMT

Hi Jordan,

Try configuring the Date attribute in the web map's pop-up property to remove the time.

1. Open the web map in the Map Viewer (either ArcGIS Online or Portal for ArcGIS).

2. Click configure pop-up for the desired layer in the web map.

3. In the Configure pop-up dialog, click Configure Attributes.

4. In the Configure Attributes window, select the date field and uncheck the Show time checkbox.

5. Click OK to save your changes.

This should remove the time stamp showing in the element, when you re-open the web map in Ops Dashboard.

Hope this helps,

Re: Operation Dashboard - Fields w/ Date data types

AnninaHirschi_Wyss1 — Mon, 05 Mar 2018 06:55:41 GMT

Hi Derek

In my dashboard I use related tables for the graphs and configured all the dates as 13/12/1997 (European, without time) in the web map. Yet the dashboard shows the dates as 12/31/1997, 12:00 AM. The charts either use the date field as value for grouping, or as category field when displaying features, for both cases "parse dates" is switched on.

Can you confirm this? Is this "as designed"? IMO, the dates should be shown as configured in the web map.

Thanks,

Annina

datetime‌

format date‌

date configuring‌

operations dashboard web version‌

Re: Operation Dashboard - Fields w/ Date data types

DerekLaw — Fri, 09 Mar 2018 20:51:10 GMT

Hi Annina,

Apologies for the late reply, I was working at the EPC/Dev Summit conferences this week.

I'm not 100% clear on the details of your workflow, can you please send me an email, detailed repro steps and perhaps some data so we can take a look? Email: dlaw@esri.com

Derek

Re: Operation Dashboard - Fields w/ Date data types

RichardNicholas1 — Tue, 01 May 2018 02:14:58 GMT

Hi Derek,

Did you find a solution to be able to display dates without the time in Operations Dashboard?

I have configured the pop-up in the web map to not show time however it does not apply this to the list in Op Dashboard.

Thanks,

Richard

Re: Operation Dashboard - Fields w/ Date data types

ChugachElectric — Wed, 02 Oct 2019 19:25:20 GMT

Derek -

We are experiencing the same thing as Richard Nicholas. I can configure the layer's popup in a web map and save it so that when I reopen the webmap, the "Show time" option is still unchecked. However, this doesn't change the list in the Dashboard, nor does it seem to be retained in the layer itself (which is the source for the Dashboard). When I open the layer in a new webmap (i.e. not the one I saved), the popup is once more set to show the time. Is there a way to edit the HTML in the Dashboard list to change the date format? Or make the Dashboard List element pull from a web map instead of a layer?

Thanks,
Jena

Re: Operation Dashboard - Fields w/ Date data types

RichardNicholas1 — Wed, 02 Oct 2019 20:25:23 GMT

Hi Jena,

I have worked around this issue by first pointing the dashboard to a web map (adding the Map item using the +) and then selecting the layer required for the List from the web map. If you change the layer pop-up from that web map (to not show time), it shouldn't show in the dashboard either.

Cheers, Richard

Re: Operation Dashboard - Fields w/ Date data types

ChugachElectric — Wed, 09 Oct 2019 15:08:33 GMT

Richard -

Adding the web map itself to the dashboard worked like a charm. Once the map was in the dashboard I was able to access the layer with the formatted popup. This particular dashboard is entirely tabular data, so the map is just tucked behind the list widget. It's now extraneous to have the map as a widget, but it does solve the extraneous date issue, which is the more noticeable of the two.

Thanks for the idea,

Jena

Re: Operation Dashboard - Fields w/ Date data types

Fab_the_lab — Thu, 14 Nov 2019 12:23:53 GMT

Great! Solved!

Re: Operation Dashboard - Fields w/ Date data types

RyanBohan — Fri, 19 Nov 2021 19:24:58 GMT

I am running into the same problem. I have a table with dates only. When I display it in a dashboard it adds a time stamp. The problem is this also shifts the date by a day. It appears to be a shift caused when appending data into portal. For some unknown reason the table on portal wants to convert time. (this is an error)

So if I do the work around to add it to a map and then remove time. Its the day before.

Re: Operation Dashboard - Fields w/ Date data types

Anonymous User — Sat, 11 Dec 2021 20:42:08 GMT

Ryan, the issue with the time stamp might be that most map and feature services use Coordinated Universal Time (UTC), which for me is 8 hrs beyond my local time zone. This pushes some records into "tomorrow". To resolve this, choose a specific time zone in the Configuration Options when publishing from ArcGIS Pro:

Re: Operation Dashboard - Fields w/ Date data types

RyanBohan — Mon, 13 Dec 2021 20:47:56 GMT

Hi GKeily,

I have tried playing around with that configuration feature. The problem is we want to append data after the layer in published. It seems using the append in model builder in Pro, when appending the time zones applied to the layer is ignored.

The only work around I have found is to have two date fields.

One for local time PST and one for UTC. If a user is consuming the data in pro, use the PST time, If they are using the data in enterprise use the UTC field.

We are a city so we never need to show things in another time zone. And if a user was accessing city data outside of the area, it would be safe to assume the data is shown in the local time.

Of course changing the way time/date is applied to the entire enterprise system as this point would be quite the task. Would be great if there was just a way to turn off the automate time conversion and just use the date exactly as entered. i.e. 12/13/2021 12:00am would always show as that time, no matter the environment it's being loaded in