Would love the "average" group by aggregation in the new table to be able to calculate an average on columns with NULL values so that the averages are calculated even though there is a null value. OR - an option to exclude zeros. My data has a lot of nulls that can either leave in place or coalesce with zero. If I coalesce with zero, the average approaches zero - well, because math. Ha! If it has null values - it just doesn't calculate an average at all.
2 Likes
Hey @darenhunter - thanks for reaching out and sharing some feedback! I just put in a feature request for this and will provide an update here as soon as possible. 