GOOGLE DATA STUDIO (Quick Tutorial): LABEL and GROUP DATA with CASE function

Tutorial on creating a calculated field to group or label data with Case Function in Data Studio in just 5 minutes! When visualise data in Pie Chart, you want to keep the number of category to NOT more than 5. One way to reduce the category, is to create a higher level grouping for the values. In this video, I shared how to use CASE formula - to group individual values into multiple categories - to add a label or category to the data source The differences between operator "=" and "IN" and their use cases are also shared with relatable examples. 📘 Reference: CASE https://support.google.com/datastudio/answer/7020724?hl=en#zippy=%2Cin-this-article F R E E B I E S I used Canva to make graphics for my education videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below! Try Canva Pro FREE for 30 days: https://partner.canva.com/danalyser [ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There's no extra cost to you.] 𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ? 👉 You can now buy me a coffee @ https://ko-fi.com/T6T25PD0A #GoogleDataStudio #CASE -------------------------------------------------------------------------------------------------------------------------- 👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages. 🌱 Learn something today and want to learn more? 👧🏻 SUBSCRIBE NOW 👉 https://www.youtube.com/channel/UCDEJmST2OTrVDFbKCUdqbxw?sub_confirmation=1 👧🏻 FOLLOW ME on TWITTER for more contents (some content are exclusive to Twitter) 👉 https://twitter.com/danalyser8/ --------------------------------------------------------------------------------------------------------------------------- 💌 MY SUGGESTED VIDEO FOR YOU: ⚈ How to work with timestamps in Data Studio? 👉 https://youtu.be/wiRcgQKfR1k ⚈ Export Data from Data Studio https://youtu.be/e7zRFvKHs08 ⚈ Automation in Data Studio (Email Delivery) https://youtu.be/A_RRbgt3qjQ ⚈ Master Filter in Data Studio 👉 https://youtu.be/ghRJxgihwIQ --------------------------------------------------------------------------------------------------------------------------- 💡 CYAD series - Customize Youtube Analytics Dashboard is an on-going project I do to build a customized dashboard for my channel. 🎥 EP1: HOW TO BUILD YOUTUBE ANALYTICS DASHBOARD USING TEMPLATE https://youtu.be/X8Lj-t35us0 🎥 EP2: HOW TO BUILD A YOUTUBE MONETIZATION TRACKER https://youtu.be/X8Lj-t35us0 🎥 EP3: HOW TO AUTOMATE YOUR DASHBOARD https://youtu.be/A_RRbgt3qjQ --------------------------------------------------------------------------------------------------------------------------- CREDITS 🎵Music: www.bensound.com