Looker Studio

From Craft of Testing - Wiki
Revision as of 09:46, 24 July 2025 by Gregpaskal (talk | contribs)
Jump to navigation Jump to search

What can we help you find?

Language Syntax
XPath Examples

Random
Home Testing Automation AI IoT OS RF Data Development References Tools Wisdom Inspiration Investing History Fun POC Help

Looker Studio is a data visualization tool that can pull data in from many sources. This Wiki entry is to capture working with Looker Studio.

Code Samples

Case - more...

CASE
  WHEN testStepDurationMS = 0 THEN null
  ELSE testStepDurationMS * 0.001
END


Concatenation - more...

CONCAT(locLatitude, ", ", locLongitude)

CONCAT(
    testCaseName,
    CASE
        WHEN testCaseRepetition > 0 THEN CONCAT(" - Repetition ", testCaseRepetition, " of ", testCaseRepetitions)
        ELSE ""
    END
)

CONCAT(
  SUBSTR(CONCAT("00", CAST(testCaseRepetition AS TEXT)), -2, 2),
  ".",
  SUBSTR(CONCAT("00", CAST(testStepRefOrder AS TEXT)), -2, 2)
)