00:00Have you ever felt an overwhelming frustration when you're trying to run an aggregation function
00:05but your data set provided to you is riddled with errors like this?
00:09Been there, done that, got myself a t-shirt. Let me demonstrate how you can still perform
00:14your aggregation function even in the midst of such chaos. Well, sort of like maneuvering a
00:19900 horsepower 4x4 truck over any terrain imaginable. We'll have to use the aggregate
00:26function under these circumstances. The first argument for that function would be the aggregation
00:31type. We will use sum for this demonstration. The second argument would be to ignore error values
00:37and finally, the last argument is the array of values to apply the aggregation to. Let's do
00:43another one for profit margin. This time around, we'll find the max value for the profit margin
00:47column. Ignore errors and select your profit margin column data set.
Comments