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.
Cross posting with similar request that probably got lost in a discussion chat instead of a feature request: [thread] New Table Feature Announcements - #41 by jg80
Please add my +1 (and the +1's from the original post )
1 Like
Hi all! We have a fix for the initial issue described here that should go live in the next couple of weeks. We're also taking this opportunity to review some of the additional feedback from the topic you linked above, @jg80!
1 Like
@Darren this is great news. Let me know if you need a beta tester. Ha!
1 Like