Looker Studio: Difference between revisions

From Craft of Testing - Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 6: Line 6:
Code Samples
Code Samples


Case<syntaxhighlight lang="javascript" line="1">
Case - [https://cloud.google.com/looker/docs/studio/case-simple more...]
<syntaxhighlight lang="javascript" line="1">
CASE
CASE
   WHEN testStepDurationMS = 0 THEN null
   WHEN testStepDurationMS = 0 THEN null

Revision as of 09:46, 24 July 2025

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)
)