How to Apply PERCENTILE Function using Calculated Field in Looker or Google Data Studio
Hey everyone Welcome to Data Millennials, I am Atul and in this video we are going to discuss How we can apply or use PERCENTILE function using Calculated Field in Looker or Google Data Studio.
So in this video we will create a table and then we are going to apply or use the PERCENTILE 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 PERCENTILE function using calculated field,
And before we use this function, let's understand the PERCENTILE function first.
Percentile is a type of Aggregation function in looker.
So PERCENTILE Returns the value at a given percentile of a specific numerical data set.
But in simpler words we can say that the percentile formula determines the performance of a person/category or you can say a value over others.
The percentile formula is used in finding where a value stands in the test compared to other values.
A percentile is a number where a certain percentage of scores fall below the given number.
So a Percentile is defined as the value below which a given percentage falls under. For example, in a group of 20 students, suppose Arpita is the 2nd rank holder in her batch and 80% of the students have scored less than her. Hence, it means that Arpita is at the 80th percentile. It is most commonly used in competitive exams
Now lets go and create a calculated field using PERCENTILE in our table
– process–
Syntax → PERCENTILE(X, N)
Parameters → X is a numeric field or expression and N - is a number in the range 1 through 99.
While using the PERCENTILE function you have to Note that the X cannot be an aggregated field or the result of an aggregation function. And N can be a decimal value.
You can follow us on the below social media handles:-
Blog: - https://thedatamillennials.blogspot.com/
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 Business Analyst who has a great Excel Skill then you can follow the below link
Excel Playlist:-https://bit.ly/3rd9cEH
If you want to become an Data Analyst or Business Analyst who has a brilliant SQL Skills then you can follow the below link
SQL Playlist:- https://bit.ly/3v28GKY
If you want to become an excellent Data visualization Analyst then you can follow the below link
Google Data Studio playlist:- https://bit.ly/3v7czyc