Looker Studio

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.

• Looker Studio

Code Samples

Case - more...

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

CASE
    WHEN CONTAINS_TEXT(LOWER(testStepResult), "pass") THEN "Pass"
    WHEN CONTAINS_TEXT(LOWER(testStepResult), "fail") THEN "Fail"
    WHEN CONTAINS_TEXT(LOWER(testStepResult), "skip") THEN "Skip"
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)
)

Count - more...

COUNT(CASE WHEN testStepExecuted = FALSE THEN 1 END)

COUNT(CASE WHEN testStepResult = "Fail" THEN 1 END)

COUNT(CASE WHEN testStepResult = "Pass" THEN 1 END)

COUNT(CASE WHEN testStepExecuted = FALSE THEN 1 END)

Current Date - more...

CURRENT_DATE()

If Else - more...

IF(LENGTH(testStepScreenshotRef) > 0, HYPERLINK(testStepScreenshotRef, "View"), "")