🔏
Faria Developer's Portal
  • Landing Page
  • Sweating the Details
    • Sweating the Details of the APIs
      • Set up Postman
      • Example Uses
    • Data Management
  • Getting Started with Google Data Studio
    • Setup raw data
      • Prepare Google Spreadsheet
      • Download from ManageBac
      • Use mb_excelexport_2csv tool
      • Placeholder
    • Re-shape raw data into DS-friendly format
    • Connect to GDS
Powered by GitBook
On this page
  • Start with a blank template:
  • Choose Google Sheets:
  • Add pivot table:
  • Modify the dimensions:
  • Add a Control
  • Make the Control set for "Full Name"
  • Add `full_name` field:
  • Final Result

Was this helpful?

  1. Getting Started with Google Data Studio

Connect to GDS

PreviousRe-shape raw data into DS-friendly format

Last updated 3 years ago

Was this helpful?

Start with a blank template:

Choose Google Sheets:

Add pivot table:

Modify the dimensions:

You will not have full_name field — this is created at a later stage. Choose first_name for now.

Add a Control

Make the Control set for "Full Name"

Add `full_name` field:

Bottom right-hand corner, find "Add a field":

Then "New Calculated Field" with this formula:

Final Result