Filled Gauge Chart
I have a gauge filled chart built that has been working each month and is now showing an error. The field I am using for the time period is Date Closed and now it makes me pick a Max Or Min. That was never showing before. Is this a change? I am trying to show the Ave Days to Close incidents base on Previous Month compared to one year ago. So a period over period graph using the filled gauge.
My formula for the Gauge Values is the following:
ROUND(AVG(DATEDIFF(`Investigation End Date`,`Investigation Start Date`)),0)
Nothing seems to work in the Date Filter either. Not sure what it wants.
Sample of when it did work