https://community.esri.com/t5/arcgis-experience-builder-questions/energy-data-in-experience-builder/m-p/1475477#M12713 <P><SPAN>I am helping interns create a dashboard showing energy usage across our campus.&nbsp; They have a test table of energy data - how many kw are being used per hour over months per building (fields incldude, dates, time of day, day of week, kw/hour, building name, etc.).&nbsp; There are thousands of records and this is only a sample of the data.&nbsp; </SPAN></P><P><SPAN>Our energy manager wants to be able to show this data over time on a map and in graphs/charts with filtering capabilities (working in Experience Builder).&nbsp; The charts are working fine if we pull the data from the table itself....what I'm having issues with is the map.&nbsp; He wants to show the buildings changing color based on their consumption, and have it update with the charts if you click a certain day or time or year, etc.</SPAN></P><P><SPAN>However, if i do a join from the bldg polygon to the energy table it creates thousands of copies of the polygons and draws so slowly.&nbsp; Is there a better way to do this?&nbsp;&nbsp;</SPAN></P><P>&nbsp;</P> Mon, 20 May 2024 15:20:37 GMT PamelaLocke1 2024-05-20T15:20:37Z https://community.esri.com/t5/arcgis-experience-builder-questions/energy-data-in-experience-builder/m-p/1475477#M12713 <P><SPAN>I am helping interns create a dashboard showing energy usage across our campus.&nbsp; They have a test table of energy data - how many kw are being used per hour over months per building (fields incldude, dates, time of day, day of week, kw/hour, building name, etc.).&nbsp; There are thousands of records and this is only a sample of the data.&nbsp; </SPAN></P><P><SPAN>Our energy manager wants to be able to show this data over time on a map and in graphs/charts with filtering capabilities (working in Experience Builder).&nbsp; The charts are working fine if we pull the data from the table itself....what I'm having issues with is the map.&nbsp; He wants to show the buildings changing color based on their consumption, and have it update with the charts if you click a certain day or time or year, etc.</SPAN></P><P><SPAN>However, if i do a join from the bldg polygon to the energy table it creates thousands of copies of the polygons and draws so slowly.&nbsp; Is there a better way to do this?&nbsp;&nbsp;</SPAN></P><P>&nbsp;</P> Mon, 20 May 2024 15:20:37 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/energy-data-in-experience-builder/m-p/1475477#M12713 PamelaLocke1 2024-05-20T15:20:37Z