pbPassingBI
/

Looker Studio essentials

Connections, charts, blends, controls and sharing. 15 cards. Click a card to flip, or use the arrow keys and space bar.

  1. Setup panel versus Style panel?

    Setup controls what the chart shows — source, dimensions, metrics, filters. Style controls how it looks.

  2. Your Sheet gives columns named "Column 1". Why?

    Title or blank rows sit above the header row. Use a named range or clean the sheet.

  3. Why does an order ID get summed?

    It is numeric, so Looker Studio treats it as a metric. Change its type to text and role to dimension in the data source.

  4. Where should reusable calculated fields be created?

    At the data source level, so every report using that source gets them.

  5. Why is SUM(a)/SUM(b) preferred over SUM(a/b) for a rate?

    Dividing the totals is correct; averaging per-row ratios weights small rows equally with large ones.

  6. Every metric in a blend is null. Cause?

    The join keys do not match in format. Normalise with a calculated field first.

  7. What must a blend join on?

    Dimensions shared by the sources, up to five sources total.

  8. One chart ignores the page date control. Why?

    It has its own date range set in Setup, which takes precedence.

  9. A filter control affects only some charts. Why?

    It only affects charts whose data source contains that field.

  10. What does cross-filtering do?

    Clicking an element in one chart filters the other charts on the page.

  11. What is the risk of owner's credentials?

    Everyone who opens the report sees data through your access, regardless of their own permissions.

  12. What filter state does a scheduled email PDF use?

    The report default, not whatever anyone last selected.

  13. Biggest lever on a slow report?

    Extract data, or aggregate upstream — every component runs its own query.

  14. Why set canvas size before building?

    Changing it later reflows every component and you reposition by hand.

  15. How do reports behave on mobile?

    The canvas scales but components do not reflow. Build a separate single-column page.