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.