Why can't I add a date field to a summary table?

154
1
12-20-2018 08:46 AM
RandyMcGregor2
Regular Contributor

I would like to create a summary table using a date field, which I need to sort this data. The data is of sample results, and sorting by date sampled is a requirement.

When I select the date field, the table icon grays out. This is true no matter how many other fields I have selected. The date field is a complete deal-breaker for the summary table, apparently.

Is there any way I can get summary table to accept a date field in Insights for ArcGIS?

Thank you,

Randy McGregor

0 Kudos
1 Reply
LindaBeale
Esri Contributor

Hi,

Currently summary tables do not support date/time fields.  The date components we add are strings so they can be added or you can do a field calculation (in the data table) to convert to a string and then display the full date.

If you want to see the data as is, there is the data table that will show you all the data (dates and all).  The data table can be docked at the bottom of your page too.

0 Kudos