Looker studio

A collection of AI skills we use at Muno Labs and share with the community

Install

npx -y skills add munolabs/skills --skill looker-studio

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Skill for creating dashboards and calculated fields in Google Looker Studio (formerly Data Studio). Use when the user: - Needs help with formulas or calculated fields in Looker Studio - Wants to connect Looker Studio to PostgreSQL/Supabase - Needs to create visualizations or dashboards - Asks about function syntax (CASE, IF, DATETIME, etc.) - Wants to convert timezones or format dates - Needs to blend data from multiple sources

SKILL.md

3.1 KB, 741 tokens by cl100k_base, as published. Nobody here has run it

Looker Studio Skill

Complete guide for creating dashboards and calculated fields in Google Looker Studio.

Main Workflow

Identify the task type:
- Create calculated field → See function references
- Connect database → See postgresql-connection.md
- Create visualization → Follow best practices
For calculated fields:
- Determine the function type needed (date, text, aggregation, logic)
- Check the corresponding reference
- Test the formula in Looker Studio

Quick Syntax Reference

Most Used Functions

-- Subtract time (e.g., convert UTC to local)
DATETIME_SUB(date_field, INTERVAL 5 HOUR)

-- Simple conditional
IF(condition, value_if_true, value_if_false)

-- Multiple conditions
CASE
  WHEN condition1 THEN result1
  WHEN condition2 THEN result2
  ELSE default_result
END

-- Default value if NULL
IFNULL(field, 'default_value')

-- Aggregations
SUM(field), AVG(field), MAX(field), MIN(field), COUNT(field)

-- Text
CONCAT(text1, text2), UPPER(text), LOWER(text)

-- Format date
FORMAT_DATETIME('%d/%m/%Y %H:%M', date_field)

Common Timezones

Timezone	Code
US Eastern	`America/New_York` (UTC-5/-4)
US Pacific	`America/Los_Angeles` (UTC-8/-7)
UK	`Europe/London` (UTC+0/+1)
Central Europe	`Europe/Berlin` (UTC+1/+2)
Australia Sydney	`Australia/Sydney` (UTC+10/+11)
India	`Asia/Kolkata` (UTC+5:30)
Japan	`Asia/Tokyo` (UTC+9)

Timezone Conversion

-- Simple method: subtract/add hours
DATETIME_SUB(utc_field, INTERVAL 5 HOUR)

-- With FORMAT for display
FORMAT_DATETIME('%Y-%m-%d %H:%M', DATETIME_SUB(field, INTERVAL 5 HOUR))

PostgreSQL/Supabase Connection

Recommended configuration:

Host: aws-X-REGION.pooler.supabase.com
Port: 5432 or 6543
Username: user.PROJECT_REF
SSL: Disabled (if causing certificate issues)

Limitations:

Maximum 150,000 rows per query
Only public schema
ASCII headers only

Available References

date-functions.md - DATETIME_ADD, DATETIME_SUB, EXTRACT, FORMAT_DATETIME
text-functions.md - CONCAT, SUBSTR, REPLACE, REGEXP_EXTRACT
aggregation-functions.md - SUM, AVG, COUNT, MAX, MIN, PERCENTILE
logic-functions.md - CASE, IF, IFNULL, COALESCE, operators
conversion-functions.md - CAST, data types
postgresql-connection.md - PostgreSQL/Supabase configuration
resources.md - Courses, tutorials, official documentation

Best Practices

Data source level calculated fields for reusability
Use IFNULL to handle null values
Avoid division by zero with NULLIF(divisor, 0)
Limit data for better performance
Use filters before complex aggregations

What ships with it: 10 files

35.8 KB alongside SKILL.md