Scan Looker-on Formula with airSlate SignNow

Comment countersign looker-on

hello everybody thank you so much for joining for this first of our five webinars in our liquor toolkit series my name is Mara Newton I'm the customer education manager at liqueur and today my fantastic team member emma.ware will be taking you through table calculations before joining the education team mo is a member of our department of customer love and handled hundreds of customer chats so she's going to share some really interesting table calculation use cases and provide some great tips and tricks for troubleshooting table talks based on her chat experience speaking of chat there is a chat panel within this webinar that you can feel free to use for any questions that you have and we'll try to address a few of those live at the end of the session this webinar is being recorded so we'll share that recording with you after the webinar is over with that I'll hand it over to Emma to dive into the content hello everyone so as Mary mentioned I'm part of the customer education team here at lookers but I did get my start as a chatter in the department of customer love so if any of you have been on chat in the past perhaps we've had the pleasure of talking just a little bit about me I am the proud cat mom of a very large Maine cat a LAN pictured here with my co-workers kitten and my background is in physics and astrophysics so why do we care as a dataxe were have you ever wondered how to divide two columns or rows in a data table or have you had the thought my analyst hasn't filled out the field that I need for my reports it's due in an hour and for the developers in the audience have you agonized over needing to add fields for a specific report but not really wanted to clutter up your model with too many of the one-off additions well if any of these scenarios seem familiar some table calculations may be the answer you're looking for table calculations provide a lightweight quick and powerful way to transform values in the data table they work pretty similar latex functions on a spreadsheet of data so these calculations are run on the numbers that we see in the table meaning they do not involve sending any new queries to your database table calculations are useful for answering one-off questions or applying transformations to the front-end data that might be complicated to do in sequel developers can use table calculations to effectively help keep the model clean by only defining fields that they want to reuse multiple times let's take a look at our agenda today we're going to start with our goals and an introduction to the building blocks of table calculations and starting with some simple some functions then you move into if functions which we'll use to create conditional logic in table calyx and then finally...