Building Calculated Fields in Data Studio
Excerpted from the CIFL course on building dashboards with Google Sheets and Data Studio:
https://learn.codingisforlosers.com/d...
Calculated fields are a super-powerful feature - they allow you to calculate new metrics, without leaving data studio.
This means you can do much less formula coding in your google sheet, and instead push that math up to data studio.
For example, if you wanted to count tweets by day of the week, you could use the WEEKDAY formula on your date column.
My favorite calculated field formulas are CASE, COUNT, and date formatting formulas like WEEKDAY.