Lukla Data Studio Docs

Docs Results

Analyzing results

Data bars, Transpose and Group By on a result set, and the summary of the selected cells, without writing another query.

On this page
  1. Data bars
  2. Transpose
  3. Group By
  4. The summary of a selection
  5. Statistics

The Analyze ▾ menu above the grid works on the result you already have, with no new query.

Revenue by country with data bars on the number columns and the top ten revenues selected; the summary shows their sum and average
Data bars on every number column, with ten revenues selected and summarised under the grid.

#Data bars

Analyze ▸ Data Bars draws a bar behind each number in proportion to the column's largest value, so the big ones stand out at a glance. The setting is remembered.

#Transpose

Analyze ▸ Transpose turns the selected rows into columns, which is easier to read for a wide row:

ColumnRow 1
ProductID1
ProductNameChai
UnitPrice18.00
UnitsInStock39

#Group By

Analyze ▸ Group By ▸ a column counts the rows per value, and sums and averages the number columns: a quick pivot without writing GROUP BY.

Transpose and Group By open as extra, read-only result tabs; on one of them, Analyze ▸ Close This Result removes it.

#The summary of a selection

Select cells and the bar under the grid summarises the active column over the selected rows:

TEXT
Revenue — 10 selected rows: 10 values · 10 distinct · Sum 1,141,778.07 · Avg 114,177.807 · Min 55,334.1 · Max 263,566.98

With nothing selected it covers every row. Column ▾ at its right picks a different column.

#Statistics

Include Statistics in the toolbar (⌥⌘I) adds a Statistics tab with the reads per table and the CPU and elapsed time; see Statistics IO and TIME.