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.
Hi Jay,
Pie charts do not support binning ranges of numeric values on the fly. One way to achieve the solution you are looking for would be calculate the bins for each data point in a new column. Then, use the Grouped value configuration and the new field as the Category field in pie charts.
-Vivek.