Looker Studio: Difference between revisions
Jump to navigation
Jump to search
Gregpaskal (talk | contribs) No edit summary |
Gregpaskal (talk | contribs) No edit summary |
||
| Line 5: | Line 5: | ||
Code Samples | Code Samples | ||
Case<syntaxhighlight lang="javascript" line="1"> | |||
CASE | |||
WHEN testStepDurationMS = 0 THEN null | |||
ELSE testStepDurationMS * 0.001 | |||
END | |||
</syntaxhighlight> | |||
Revision as of 09:43, 24 July 2025
|
What can we help you find? |
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
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)
)