When building a new chart, I want to find out the average days based on the distinct values of the JcId column. How can I achieve this as an aggregate formula? If I just drag the Days to the Y-axis and set it as Avg, it averages all rows and displays the answer as 2.67 (4+4+0/3) where it should just be 2 (4/2).