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...
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 👉 / @danalyser
👧🏻 FOLLOW ME on TWITTER for more contents (some content are exclusive to Twitter) 👉 / danalyser8
---------------------------------------------------------------------------------------------------------------------------
💌 MY SUGGESTED VIDEO FOR YOU:
⚈ How to work with timestamps in Data Studio? 👉
• Google Data Studio Tutorial | How to work ...
⚈ Export Data from Data Studio
• How to Export Data From Google Data Studio...
⚈ Automation in Data Studio (Email Delivery)
• How to automate data studio report? ✉️ Sch...
⚈ Master Filter in Data Studio 👉
• Google Data Studio Tutorials | Master Filt...
---------------------------------------------------------------------------------------------------------------------------
💡 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
• How To Build A MONETIZATION TRACKER For Yo...
🎥 EP2: HOW TO BUILD A YOUTUBE MONETIZATION TRACKER
• How To Build A MONETIZATION TRACKER For Yo...
🎥 EP3: HOW TO AUTOMATE YOUR DASHBOARD
• How to automate data studio report? ✉️ Sch...
---------------------------------------------------------------------------------------------------------------------------
CREDITS
🎵Music: www.bensound.com