greetings acolytes and welcome back to the Duke's digital layer on this all hours Eve we will explore dark and Arcane service now Roar and thou must be treated how the house behold long hostile labored tracking the efforts of thy minions in their evil Deeds collecting screams and nightmares for their dark Patron now thou wishes to apply sorcerer's incantations via stripped on aggregation of these bowel metrics on dark lord need not calculate Aggregates one at a time when the secret of light Aggregates revealed let us Define dark insights from our evil Deeds such as the sums and averages of the Stream nightmares we have created first we invoke a variable named deed and make it a Glide aggregate on our evil Deeds table let us also use the sorcery of AD encoded query so we may select Deeds rendered in the last two fortnights Andrew's Target is that medley do-gooder Sean Bennett follow the eye if you need instruction in the ways of adding coded query command the void with thy function add aggregate to Divine without Wills with glide aggregate a dark lord May defy an account some average minimum maximum and standard deviation of properties in thy tables follow the I if you need instruction on standard deviation we count the numbers and take some an average of the screams and Nightmares are foul Deeds of rot if thou need not group thy results thou must assuredly set group to false lest thy efforts are in vain then as we would in Glide record we command the void to query now that thou has prepared the ad Aggregates in a Glide aggregate query thou may now Leverage The get aggregate function know this well accolades that before you can use and get aggregate function you must first have had a similar ad aggregate witness our setting variables of the sums and averages of nightmares and screen get aggregate functions to match our ad Aggregates we command the void to present us these insights in a GS info message we also wielded the get total function which counts all records that were part of the query witness how a this should be should be this active divination has summoned our insights while the plants labor and Bane to extract the same wisdom in the library let us learn the secrets of the group by function verily your nefarious plans come in many types and you seek wisdom by taking Aggregates by grouping data we wish to describe which plans had the highest sun and average of Screams and Nightmares here we query and add Aggregates according to our will but importantly regroup by type of D we invoke variables to track the name of the deep type the sum of the screens and the average of the nightmares within the wild we summon the proper display name of the Deeds type we then set the variables with the get aggregate function we then command the void to tell us the Deep type some of the screams and average of the nightmares now witness as Glide aggregate has grouped each of the Aggregates by their type and now let us explore the secrets of adtrend verily your nefarious Deeds do not bear fruit overnight it's dry the Aggregates of our screams and nightmares over the months their deeds were opened observe thy script where we command Glide record with the add Trend function we specify the date time field and what spam desire to trend on then within our script we invoke a variable to store the value of the time frame then we command the void to tell us the time reference the sum of the screens and the average of the nightmares now witness as Glide aggregate has grouped the Aggregates into the months of their Reckoning let us learn the secrets of order by Aggregate and add having an Overlord must have ordered so wield the order by aggregate function to set the aggregate you wish to sort by in our script we have commanded Glide record to order by aggregate some of our screens now witness how Glide aggregate has shown how promoting ESG has yielded the most streams as if any had courage to doubt an Overlord also has no interest in Petty results so wield had having function to set a threshold on an aggregate to appear in the results in our script we command the Glide aggregate via odd having to ensure only Aggregates where the sum of the screams is greater than 150. now witness how promotion of ESG alone is capable of meeting our tyrannical standard with the secrets of Glide aggregate thus revealed unto thee go forth and manifest thy Destiny what will you do with this power laughs [Laughter] if you wish to sponsor this digital where's various Arcana email the Duke at the address appearing before you if you have clean secret keys of insight to descend into deeper lore consider a tribute to the layers coffers if that were merely entertained share this Spell among your networks as a playground shares its blessings upon the masses I remain Yours Truly in darkness the nuke