I have a rental permit dataset. In retrieving the data through an SQL spatial view I calculate the number of days until the permit will expire or has expired. Positive values indicate days until the permit expires. Negative values are the number of days since the permit expired. I would like to use a pie chart to show the number and percent of expired permits that are 30, 60, 90, and 180+ days past their expiration date. Is this possible? I have tried several combinations of filters, slice configurations, etc. with no luck. Thanks in advance.
