How to use COALESCE function using Calculated Field in Looker | How to get another column value
So in this video we will create this a table and then we are going to apply or use the COALESCE 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 COALESCE function using calculated field,
And before we use this function, let's understand the COALESCE function first.
COALESCE function is a conditional function in looker and it Returns the first non-missing value found in a list of fields.
Now lets go and create a calculated field using COALESCE in our table
– process–
Syntax
COALESCE(field_expression[, field_expression, ...])
Parameters
field_expression - it is a field or expression. All field_expressions must be of the same type.
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