topic Re: Date Field in Pie Chart - Dashboard or Experience Builder in ArcGIS Dashboards Questions

Date Field in Pie Chart - Dashboard or Experience Builder

PamelaLocke1 — Mon, 04 Dec 2023 15:54:07 GMT

We are trying to create a pie chart showing EUI (Energy Use Intensity) over time. Our data is at 5-minute intervals. Is there a way to average the EUI per month and show one slice per month in a pie chart?

Currently, we cannot select the date field (which is a date data type field) as an option for pie charts. We can filter by date, but that's not quite showing what we want.

Re: Date Field in Pie Chart - Dashboard or Experience Builder

clt_cabq — Mon, 04 Dec 2023 15:59:16 GMT

While I think there are probably better ways to display this information than a Pie Chart, can you just create a text field that contains the name of the month you are interested in (alternatively an integer field numbered 1-12 for the months which would sort better more easily than a text field)?

Re: Date Field in Pie Chart - Dashboard or Experience Builder

DavidPike — Mon, 04 Dec 2023 17:46:51 GMT

Probably just a data expression with a new field created form Month() of the datetime.