Different Ways to Use Aggregate Functions

[Banderson (Brandon Anderson)]

What do you mean “outside of a subquery”? Do you mean without grouping?

You can use windowing functions to use aggregates without grouping. Here’s a video with a bunch of tips.

BAQ Calculated fields insights presentation

Hey Everyone, This is a recording done after the fact of my insights presentation due to the technical difficulties I had during the presentation. Now I was able to record all of the live things that I wanted to show. I will apologize for my fat head in the way for some of it, but I thought it would be better if you could see me talking instead of just a disembodied voice. And I didn’t feel like taking the time to figure out how to use active presenter well enough to do some editing, so you ge…