How to apply or use IFNULL function using Calculated Field in Looker | Use IFNULL Function in Looker
So in this video we will create this a table and then we are going to apply or use the IFNULL function as a calculated field in our charts or tables from scratch so that you can get the awareness that when where and how we can apply the IFNULL function using calculated field,
And before we use this function, let's understand the IFNULL function first.
IFNULL function is a conditional function in looker and it Returns a result if the input is null, otherwise, returns the input.
Now lets go and create a calculated field using IFNULL in our table
– process–
Syntax
IFNULL(input_expression, null_result)
Parameters
input_expression
The expression to evaluate. You can use any valid expression as the input_expression.
null_result
The result to return if input_expression is null. If input_expression is not null, IFNULL returns the input_expression. You can use any valid expression as the input_expression.
You can follow us on the below social media handles:-
Youtube: - / @thedatamillennials
Facebook:- / the-data-millennials-596575371027542
Instagram: - / the_data_millennials
LinkedIn: - / data-millennials-6b5a031b3
Twitter: - / datamillennials
If you want to be become an Data Analyst or BuCASEess Analyst who has a great analytical Skill then you can follow the below links
Excel Playlist:-https://bit.ly/3rd9cEH
SQL Playlist:- https://bit.ly/3v28GKY
Google Data Studio playlist:- https://bit.ly/3v7czyc