How I Calculate Weekly (WoW) Growth Rate in Data Studio Using Data Blend (Self Join Method Example)
Week-over-Week is critical to measure a business' success! In this tutorial, I'll explain how I managed to count weekly growth using sales data with "DATE" and "TOTAL ORDER" field in Google Data Studio (GDS) using Blended Data Solution.
You may use the same concept shown in this video for date / week / month (MoM) / quarter / year (YoY) comparison with some tweaks in the formulas.
Blend Data is extremely useful when you're dealing with more advanced calculation and visualisation needs. Here are some other applications:
D A T A B L E N D T U T O R I A L S 👇
⇨ Grouping Data using Aggregated Metrics: • DATA BLEND TUTORIAL: How to create groupin...
⇨ Calculate Percentage: • How to Calculate Percentage (%) Scorecard ...
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
👉 You can now buy me a coffee @ https://ko-fi.com/T6T25PD0A
👉 Subscribe to my channel @ https://www.youtube.com/c/Danalyser?s...
👉 Shop Danalyser Templates Collection
@ www.danalyser.com
#GoogleDataStudio #Danalyser
T I M E S T A M P
00:00 How the solution works ? Concept Explained
03:18 Step 1: Group Dates to Week Number (Data Blend)
05:15 Step 2: Self Join to Get Last Week's Amount
07:55 Step 3: Add Calculated Field to Count Percentage Change
09:05 Adding Percentage Change to Line / Bar Chart
10:45 Style Modification to Adjust Labels Scale
⭐️ NEW TO GOOGLE DATA STUDIO
Check out our FREE GDS Course (2022) here 👉 • FULL Google Data Studio Course (2023) ➡️ r...
We uses practical approach and covers almost everything you need to get started in Google Data Studio! Take the course now and shine ✨
F R E E B I E S
I used Canva to make graphics for my educational 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.]
--------------------------------------------------------------------------------------------------------------------------
A B O U T M E
👧🏻 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.