Craft of Testing - Wiki - User contributions [en]

IoT - ESP32 S3 Touch AMOLED 1.8

2025-10-18T21:23:13Z

Gregpaskal:

{{: Header_Nav}}

= This page is about the ESP32 S3 Touch AMOLED 1.8 Microcontroller =

== Waveshare - Touch ==
'''Waveshare''': https://www.waveshare.com/esp32-s3-touch-amoled-1.8.htm
'''Amazon''': https://www.amazon.com/dp/B0F242GFHK?ref=ppx_yo2ov_dt_b_fed_asin_title

Specifications:
ESP32-S3 1.8inch AMOLED Touch Display Development Board, 32-bit LX7 Dual-core Processor, 368×448 Pixels, Accelerometer And Gyroscope Sensor, ESP32 With Display

'''ESP32-S3-Touch-AMOLED-1.8''' is a low-cost, high-performance MCU board designed by Waveshare, tiny size, with onboard 1.8inch AMOLED display, power management IC, 6-axis sensor (3-axis accelerometer and 3-axis gyroscope), RTC, low power audio codec, and so on, which makes it easy for you to develop and integrate it into the products quickly.

'''Key features include:'''

* Equipped with ESP32-S3R8 Xtensa 32-bit LX7 dual-core processor, up to 240MHz main frequency
* Supports 2.4GHz Wi-Fi (802.11 b/g/n) and Bluetooth 5 (LE), with onboard antenna
* Built in 512KB of SRAM and 384KB ROM, with onboard 8MB PSRAM and an external 16MB Flash memory
* Type-C connector, improving device compatibility, easier to use
* Onboard 1.8inch AMOLED display for clear color picture display, 368 × 448 resolution, 16.7M color
* Built-in SH8601 display driver and FT3168 capacitive touch chip, using QSPI and I2C communication respectively, effectively saving the IO resources
* Onboard QMI8658 6-axis IMU (3-axis accelerometer and 3-axis gyroscope) for detecting motion gesture, counting steps, etc.
* Onboard PCF85063 RTC chip, powered by main Lithium battery through AXP2101 chip, with reserved RTC battery pads for connecting a backup battery, ensuring RTC function during the replacement of the main battery
* Onboard PWR and BOOT programmable buttons for easy custom function development
* Onboard 3.7V MX1.25 Lithium battery recharge/discharge header, optional for 3.7V Lithium battery
* Reserved pads of 7 × GPIO, 1 × I2C, 1 × UART, and 1 × USB interface, for connecting peripherals and debugging
* Onboard TF card slot for extended storage and fast data transfer, suitable for applications such as data recording and media playback, simplifying circuit design
* Adopts AXP2101 IC for efficient power management, supports multiple voltage outputs, battery charging, battery management, and battery life optimization, etc.
* Adopts AMOLED screen, featuring advantages of high contrast, wide viewing angle, rich colors, fast response, thinner design, and low power consumption, etc.

{| class="wikitable"
!Display Panel
|AMOLED
!Display Size
|1.8 inch
|-
!Resolution
|368 × 448 pixels
!Display Colors
|16.7M
|-
!Brightness
|350 cd/㎡
!Contrast Ratio
|100000:1
|-
!Communication Interface
|QSPI
!Driver IC
|SH8601
|-
!Touch
|Supported
!Touch IC
|FT3168
|}
Adopts AMOLED screen

The next-generation display technology, compared to those traditional LCD displays, the AMOLED screen features precise light-control capability, representing more delicate colors, more picture details, and more vivid video image

Wi-Fi and BLE 5 support

ESP32-S3 integrates 2.4 GHz Wi-Fi (802.11 ax/b/g/n) with 40 MHz of bandwidth support, Its Bluetooth Low Energy subsystem supports Bluetooth 5 (LE) and Bluetooth Mesh

[[File:ESP32-S3-Touch-AMOLED-1.8-intro.jpg]]

# '''ESP32-S3R8''' The SoC with WiFi and Bluetooth, up to 240MHz operating frequency, with onboard 8MB PSRAM
# '''QMI8658''' 6-axis IMU includes a 3-axis gyroscope and a 3-axis accelerometer
# '''PCF85063''' RTC chip
# '''AXP2101''' Highly integrated power management IC
# '''ES8311''' Low power mono audio codec
# '''Speaker'''
# '''Backup battery pads''' for connecting backup battery, ensuring RTC function during the replacement of the main battery
# '''MX1.25 Lithium battery header''' MX1.25 2P connector, for 3.7V Lithium battery (optional), supports charging and discharging. (To fit inside the case, a battery size of 3.85 × 24 × 28 mm is recommended)
# '''16MB NOR-Flash''' for storing data
# '''Microphone'''
# '''Onboard antenna''' Supports 2.4 GHz Wi-Fi (802.11 b/g/n) and Bluetooth 5 (LE)
# '''Reserved GPIO pads (pitch 1mm)''' Adopting available IO function pins for easy expansion
# '''BOOT button''' for device startup and function debugging
# '''USB Type-C port''' ESP32-S3 USB interface, for programming and log printing
# '''PWM button''' for system power supply ON/OFF, supports custom functions

[[File:ESP32-S3-Touch-AMOLED-1.8-details-15.jpg]]

File:ESP32-S3-Touch-AMOLED-1.8-details-15.jpg

2025-10-18T21:21:13Z

Gregpaskal:

Pinout

IoT - ESP32 S3 Touch AMOLED 1.8

2025-10-18T21:20:37Z

Gregpaskal:

IoT - ESP32 S3 Touch AMOLED 1.8

2025-10-18T21:19:23Z

Gregpaskal:

IoT - ESP32 S3 Touch AMOLED 1.8

2025-10-18T21:19:06Z

Gregpaskal:

File:ESP32-S3-Touch-AMOLED-1.8-intro.jpg

2025-10-18T21:18:35Z

Gregpaskal:

PCB Layout

IoT - ESP32 S3 Touch AMOLED 1.8

2025-10-18T21:07:55Z

Gregpaskal:

IoT - ESP32 S3 Touch AMOLED 1.8

2025-10-18T21:05:53Z

Gregpaskal: Created page with "{{: Header_Nav}} = This page is about the ESP32 S3 Touch AMOLED 1.8 Microcontroller = == Waveshare - Touch == '''Waveshare''': https://www.waveshare.com/esp32-s3-touch-amoled-1.8.htm"

{{: Header_Nav}}

= This page is about the ESP32 S3 Touch AMOLED 1.8 Microcontroller =

== Waveshare - Touch ==
'''Waveshare''': https://www.waveshare.com/esp32-s3-touch-amoled-1.8.htm

IoT

2025-10-18T21:02:38Z

Gregpaskal:

{{: Header_Nav}}
This section is all about the Internet of Things (IoT)

=== Hardware ===

* [[Raspberry Pi]]
* [[Arduino]]
* [[LILYGO T-PicoC3]]
* [[IoT - ESP32]]
* [[IoT - ESP32_DevKit]]
* [[IoT - ESP32 Wroom]]
* [[IoT - ESP32 Wrover]]
* [[IoT - ESP32 S3 T-Display]]
* [[IoT - ESP32 S3 Touch AMOLED 1.8]]
* [[IoT - ESP32 C3 - XIAO]]
* [[IoT - ESP32 C3 Mini 1 - ESPRESSIF]]
* [[IoT - ESP32 C6 Touch LCD 1.47 M]]
* [https://github.com/Xinyuan-LilyGO/T-PicoC3 Xinyuan-LilyGO T-PicoC3]
* [[LiPo Fuel Gauge - MAX17043]]
* [[OLED Display]]
* [[HiLetg Bi-Directional DC Current Power Supply Sensor - INA219 I2C]]
* [[IoT - LiPo Fuel Gauge MAX17043]]

=== Simulators ===

* [https://wokwi.com/ Wokwi - An online Microcontroller IDE and Simulator]

=== I2C - (Inter-Integrated Circuit) / TWI (Two-wire Interface ===
* [[I2C]]

=== Wifi ===
* [[Wifi]]

=== ELK ===
* [[ELK]]

=== LoRa ===
* [[LoRa]]

=== Mac - USB to Serial ===

* [https://github.com/Xinyuan-LilyGO/CH9102_Mac_Driver/blob/main/CH34X_DRV_INSTALL_INSTRUCTIONS.pdf CH34X USB-to_Serial MocOS Driver]
* [https://forums.raspberrypi.com/viewtopic.php?t=301092 Serial Communication To Mac over USB]

=== YouTube ===

* [https://www.youtube.com/c/VolosProjects Volos Projects]

=== Articles ===

* [https://sixfab.com/raspberry-pi-vs-arduino-which-is-better-for-iot-projects/?utm_medium=ppc&utm_campaign=Performance+Max+%7C+US&utm_term=&utm_source=adwords&hsa_src=x&hsa_net=adwords&hsa_kw=&hsa_tgt=&hsa_ad=&hsa_grp=&hsa_mt=&hsa_acc=6308888758&hsa_ver=3&hsa_cam=15788293172&gclid=CjwKCAjw4JWZBhApEiwAtJUN0BVBFj1U2bPc3rv6rWSFiPLtk7vMvRjpIEOJfPKhklcEnmz9hqAyoxoCkXwQAvD_BwE Raspberry Pi vs. Arduino]
* [https://www.tomshardware.com/news/raspberry-pi-rp2040-esp32-together LilyGO T-PicoC3 Combines RP2040 and ESP32 in a Single Board]
* [https://projects.raspberrypi.org/en/projects/getting-started-with-the-pico Intro to Raspberry Pi]
* [https://www.youtube.com/watch?v=OZoi3eChwHw How to setup Raspberry Pi Pico on a Mac]
* [https://www.thebackshed.com/forum/ViewTopic.php?FID=16&TID=14856 T-PicoC3 display works great, pros and cons]
* [https://www.instructables.com/Setup-JetBrains-Clion-for-Arduino-Development/ Setup JetBrains Clion for Arduino Development]
* [https://blog.jetbrains.com/clion/2020/08/arduino-from-hobby-to-prof-p1/ Arduino Development with CLion: From Hobby to Professional Project. Part I]
* [https://learn.sparkfun.com/tutorials/i2c/all Inter-Integrated Circuit (I2C) Protocol]
* [https://github.com/HomeSpan/HomeSpan Apple Homekit for ESP32]
[[index.php?title=Category:IoT]]

IoT - ESP32 C6 Touch LCD 1.47 M

2025-09-05T23:15:49Z

Gregpaskal:

{{: Header_Nav}}
This section is all about the ESP32 C6 Touch LCD 1.47 M

https://www.waveshare.com/esp32-c6-lcd-1.47.htm

https://www.waveshare.com/wiki/ESP32-C6-LCD-1.47

[[File:ESP32-C6-LCD-1.47-details-9.jpg]]

File:ESP32-C6-LCD-1.47-details-9.jpg

2025-09-05T23:14:07Z

Gregpaskal:

Supports multiple peripherals
Supports the expansion of multiple peripherals via GPIO header

IoT - ESP32 C6 Touch LCD 1.47 M

2025-09-05T23:12:20Z

Gregpaskal:

{{: Header_Nav}}
This section is all about the ESP32 C6 Touch LCD 1.47 M

https://www.waveshare.com/esp32-c6-lcd-1.47.htm

IoT - ESP32 C6 Touch LCD 1.47 M

2025-09-05T23:11:25Z

Gregpaskal: Created page with "{{: Header_Nav}} This section is all about the ESP32 C6 Touch LCD 1.47 M"

{{: Header_Nav}}
This section is all about the ESP32 C6 Touch LCD 1.47 M

IoT

2025-09-05T23:10:29Z

Gregpaskal:

{{: Header_Nav}}
This section is all about the Internet of Things (IoT)

=== Hardware ===

* [[Raspberry Pi]]
* [[Arduino]]
* [[LILYGO T-PicoC3]]
* [[IoT - ESP32]]
* [[IoT - ESP32_DevKit]]
* [[IoT - ESP32 Wroom]]
* [[IoT - ESP32 Wrover]]
* [[IoT - ESP32 S3 T-Display]]
* [[IoT - ESP32 C3 - XIAO]]
* [[IoT - ESP32 C3 Mini 1 - ESPRESSIF]]
* [[IoT - ESP32 C6 Touch LCD 1.47 M]]
* [https://github.com/Xinyuan-LilyGO/T-PicoC3 Xinyuan-LilyGO T-PicoC3]
* [[LiPo Fuel Gauge - MAX17043]]
* [[OLED Display]]
* [[HiLetg Bi-Directional DC Current Power Supply Sensor - INA219 I2C]]
* [[IoT - LiPo Fuel Gauge MAX17043]]

=== Simulators ===

* [https://wokwi.com/ Wokwi - An online Microcontroller IDE and Simulator]

=== I2C - (Inter-Integrated Circuit) / TWI (Two-wire Interface ===
* [[I2C]]

=== Wifi ===
* [[Wifi]]

=== ELK ===
* [[ELK]]

=== LoRa ===
* [[LoRa]]

=== Mac - USB to Serial ===

* [https://github.com/Xinyuan-LilyGO/CH9102_Mac_Driver/blob/main/CH34X_DRV_INSTALL_INSTRUCTIONS.pdf CH34X USB-to_Serial MocOS Driver]
* [https://forums.raspberrypi.com/viewtopic.php?t=301092 Serial Communication To Mac over USB]

=== YouTube ===

* [https://www.youtube.com/c/VolosProjects Volos Projects]

=== Articles ===

* [https://sixfab.com/raspberry-pi-vs-arduino-which-is-better-for-iot-projects/?utm_medium=ppc&utm_campaign=Performance+Max+%7C+US&utm_term=&utm_source=adwords&hsa_src=x&hsa_net=adwords&hsa_kw=&hsa_tgt=&hsa_ad=&hsa_grp=&hsa_mt=&hsa_acc=6308888758&hsa_ver=3&hsa_cam=15788293172&gclid=CjwKCAjw4JWZBhApEiwAtJUN0BVBFj1U2bPc3rv6rWSFiPLtk7vMvRjpIEOJfPKhklcEnmz9hqAyoxoCkXwQAvD_BwE Raspberry Pi vs. Arduino]
* [https://www.tomshardware.com/news/raspberry-pi-rp2040-esp32-together LilyGO T-PicoC3 Combines RP2040 and ESP32 in a Single Board]
* [https://projects.raspberrypi.org/en/projects/getting-started-with-the-pico Intro to Raspberry Pi]
* [https://www.youtube.com/watch?v=OZoi3eChwHw How to setup Raspberry Pi Pico on a Mac]
* [https://www.thebackshed.com/forum/ViewTopic.php?FID=16&TID=14856 T-PicoC3 display works great, pros and cons]
* [https://www.instructables.com/Setup-JetBrains-Clion-for-Arduino-Development/ Setup JetBrains Clion for Arduino Development]
* [https://blog.jetbrains.com/clion/2020/08/arduino-from-hobby-to-prof-p1/ Arduino Development with CLion: From Hobby to Professional Project. Part I]
* [https://learn.sparkfun.com/tutorials/i2c/all Inter-Integrated Circuit (I2C) Protocol]
* [https://github.com/HomeSpan/HomeSpan Apple Homekit for ESP32]
[[index.php?title=Category:IoT]]

Looker Studio

2025-07-24T19:39:05Z

Gregpaskal:

{{: Header_Nav}}
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.

*[https://lookerstudio.google.com/ Looker Studio]

== Code Samples ==

=== Case - [https://cloud.google.com/looker/docs/studio/case-simple more...] ===
<syntaxhighlight lang="javascript" line="1">
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
</syntaxhighlight>

=== Concatenation - [https://cloud.google.com/looker/docs/studio/concat?visit%20id=638889681685168930-3176560615&rd=1 more...] ===
<syntaxhighlight lang="javascript" line="1">
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)
)
</syntaxhighlight>

=== Count - [https://cloud.google.com/looker/docs/studio/count more...] ===
<syntaxhighlight lang="javascript">
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)
</syntaxhighlight>

=== Current Date - [https://cloud.google.com/looker/docs/studio/currentdate more...] ===
<syntaxhighlight lang="javascript">
CURRENT_DATE()
</syntaxhighlight>

=== If Else - [https://cloud.google.com/looker/docs/studio/if more...] ===
<syntaxhighlight lang="javascript">
IF(LENGTH(testStepScreenshotRef) > 0, HYPERLINK(testStepScreenshotRef, "View"), "")
</syntaxhighlight>

Looker Studio

2025-07-24T16:01:19Z

Gregpaskal: /* Color Samples */

{{: Header_Nav}}
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.

*[https://lookerstudio.google.com/ Looker Studio]

== Code Samples ==

=== Case - [https://cloud.google.com/looker/docs/studio/case-simple more...] ===
<syntaxhighlight lang="javascript" line="1">
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
</syntaxhighlight>

=== Concatenation - [https://cloud.google.com/looker/docs/studio/concat?visit%20id=638889681685168930-3176560615&rd=1 more...] ===
<syntaxhighlight lang="javascript" line="1">
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)
)
</syntaxhighlight>

=== Current Date - [https://cloud.google.com/looker/docs/studio/currentdate more...] ===
<syntaxhighlight lang="javascript">
CURRENT_DATE()
</syntaxhighlight>

=== If Else - [https://cloud.google.com/looker/docs/studio/if more...] ===
<syntaxhighlight lang="javascript">
IF(LENGTH(testStepScreenshotRef) > 0, HYPERLINK(testStepScreenshotRef, "View"), "")
</syntaxhighlight>

== Color Samples ==
{| class="wikitable"
|+
!
!
!
!
|-
|
|
|
|
|-
|
|
|
|
|-
|
|
|
|
|}

Looker Studio

2025-07-24T15:59:53Z

Gregpaskal:

{{: Header_Nav}}
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.

*[https://lookerstudio.google.com/ Looker Studio]

== Code Samples ==

=== Case - [https://cloud.google.com/looker/docs/studio/case-simple more...] ===
<syntaxhighlight lang="javascript" line="1">
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
</syntaxhighlight>

=== Concatenation - [https://cloud.google.com/looker/docs/studio/concat?visit%20id=638889681685168930-3176560615&rd=1 more...] ===
<syntaxhighlight lang="javascript" line="1">
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)
)
</syntaxhighlight>

=== Current Date - [https://cloud.google.com/looker/docs/studio/currentdate more...] ===
<syntaxhighlight lang="javascript">
CURRENT_DATE()
</syntaxhighlight>

=== If Else - [https://cloud.google.com/looker/docs/studio/if more...] ===
<syntaxhighlight lang="javascript">
IF(LENGTH(testStepScreenshotRef) > 0, HYPERLINK(testStepScreenshotRef, "View"), "")
</syntaxhighlight>

== Color Samples ==

Looker Studio

2025-07-24T15:54:34Z

Gregpaskal:

{{: Header_Nav}}
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.

*[https://lookerstudio.google.com/ Looker Studio]

== Code Samples ==

=== Case - [https://cloud.google.com/looker/docs/studio/case-simple more...] ===
<syntaxhighlight lang="javascript" line="1">
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
</syntaxhighlight>

=== Concatenation - [https://cloud.google.com/looker/docs/studio/concat?visit%20id=638889681685168930-3176560615&rd=1 more...] ===
<syntaxhighlight lang="javascript" line="1">
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)
)
</syntaxhighlight>

=== Current Date - [https://cloud.google.com/looker/docs/studio/currentdate more...] ===
<syntaxhighlight lang="javascript">
CURRENT_DATE()
</syntaxhighlight>

=== If Else - [https://cloud.google.com/looker/docs/studio/if more...] ===
<syntaxhighlight lang="javascript">
IF(LENGTH(testStepScreenshotRef) > 0, HYPERLINK(testStepScreenshotRef, "View"), "")
</syntaxhighlight>

Looker Studio

2025-07-24T15:54:05Z

Gregpaskal:

{{: Header_Nav}}
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.

*[https://lookerstudio.google.com/ Looker Studio]

== Code Samples ==

=== Case - [https://cloud.google.com/looker/docs/studio/case-simple more...] ===
<syntaxhighlight lang="javascript" line="1">
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
</syntaxhighlight>

=== Concatenation - [https://cloud.google.com/looker/docs/studio/concat?visit%20id=638889681685168930-3176560615&rd=1 more...] ===
<syntaxhighlight lang="javascript" line="1">
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)
)
</syntaxhighlight>

=== Current Date - [https://cloud.google.com/looker/docs/studio/currentdate more...] ===
<syntaxhighlight lang="javascript">
CURRENT_DATE()
</syntaxhighlight>

=== If Else - [https://cloud.google.com/looker/docs/studio/if more...] ===
<syntaxhighlight lang="javascript">
IF(LENGTH(testStepScreenshotRef) > 0, HYPERLINK(testStepScreenshotRef, "View"), "")
</syntaxhighlight>

Looker Studio

2025-07-24T15:52:01Z

Gregpaskal:

{{: Header_Nav}}
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.

*[https://lookerstudio.google.com/ Looker Studio]

== Code Samples ==

=== Case - [https://cloud.google.com/looker/docs/studio/case-simple more...] ===
<syntaxhighlight lang="javascript" line="1">
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
</syntaxhighlight>

=== Concatenation - [https://cloud.google.com/looker/docs/studio/concat?visit%20id=638889681685168930-3176560615&rd=1 more...] ===
<syntaxhighlight lang="javascript" line="1">
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)
)
</syntaxhighlight>

=== If Else - [https://cloud.google.com/looker/docs/studio/if more...] ===
<syntaxhighlight lang="javascript">
IF(LENGTH(testStepScreenshotRef) > 0, HYPERLINK(testStepScreenshotRef, "View"), "")
</syntaxhighlight>

Looker Studio

2025-07-24T15:51:03Z

Gregpaskal:

{{: Header_Nav}}
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.

*[https://lookerstudio.google.com/ Looker Studio]

== Code Samples ==

=== Case - [https://cloud.google.com/looker/docs/studio/case-simple more...] ===
<syntaxhighlight lang="javascript" line="1">
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
</syntaxhighlight>

=== Concatenation - [https://cloud.google.com/looker/docs/studio/concat?visit%20id=638889681685168930-3176560615&rd=1 more...] ===
<syntaxhighlight lang="javascript" line="1">
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)
)
</syntaxhighlight>

=== If Else - [https://cloud.google.com/looker/docs/studio/if] ===
<syntaxhighlight lang="javascript">
IF(LENGTH(testStepScreenshotRef) > 0, HYPERLINK(testStepScreenshotRef, "View"), "")
</syntaxhighlight>

Looker Studio

2025-07-24T15:49:18Z

Gregpaskal:

Looker Studio

2025-07-24T15:47:01Z

Gregpaskal:

Looker Studio

2025-07-24T15:46:04Z

Gregpaskal:

Looker Studio

2025-07-24T15:43:56Z

Gregpaskal:

{{: Header_Nav}}
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.

*[https://lookerstudio.google.com/ Looker Studio]

Code Samples

Case<syntaxhighlight lang="javascript" line="1">
CASE
WHEN testStepDurationMS = 0 THEN null
ELSE testStepDurationMS * 0.001
END
</syntaxhighlight>

Concatenation - [https://cloud.google.com/looker/docs/studio/concat?visit%20id=638889681685168930-3176560615&rd=1 more...]
<syntaxhighlight lang="javascript" line="1">
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)
)
</syntaxhighlight>

Looker Studio

2025-07-24T15:42:01Z

Gregpaskal:

Looker Studio

2025-07-24T15:40:43Z

Gregpaskal:

Looker Studio

2025-07-24T15:39:52Z

Gregpaskal:

Looker Studio

2025-07-24T15:38:18Z

Gregpaskal:

Looker Studio

2025-07-24T15:37:32Z

Gregpaskal:

Looker Studio

2025-07-24T15:33:29Z

Gregpaskal:

Looker Studio

2025-07-24T13:11:42Z

Gregpaskal:

Looker Studio

2025-07-24T13:09:53Z

Gregpaskal: Created page with "{{: Header_Nav}} 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. *Datalake - Google Cloud Platform"

{{: Header_Nav}}
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.

*[[Datalake - Google Cloud Platform]]

Data

2025-07-24T13:08:07Z

Gregpaskal:

{{: Header_Nav}}
This section is all about Data

*[[Datalake]]
*[[Looker Studio]]
*[[SQL]]

Main Page

2025-04-05T22:42:25Z

Gregpaskal:

{{: Header_Nav}}

== Welcome ==
Welcome to the CraftOfTesting wiki where I share some of my best tools and practices in Testing, Automation and Innovating. I add frequently here so check back often to see what new and what can help you to in your craft as a technologist.

== Latest additions ==
{{Special:Newestpages/-/10}}

IoT

2025-04-05T22:41:54Z

Gregpaskal:

{{: Header_Nav}}
This section is all about the Internet of Things (IoT)

=== Hardware ===

* [[Raspberry Pi]]
* [[Arduino]]
* [[LILYGO T-PicoC3]]
* [[IoT - ESP32]]
* [[IoT - ESP32_DevKit]]
* [[IoT - ESP32 Wroom]]
* [[IoT - ESP32 Wrover]]
* [[IoT - ESP32 S3 T-Display]]
* [[IoT - ESP32 C3 - XIAO]]
* [[IoT - ESP32 C3 Mini 1 - ESPRESSIF]]
* [https://github.com/Xinyuan-LilyGO/T-PicoC3 Xinyuan-LilyGO T-PicoC3]
* [[LiPo Fuel Gauge - MAX17043]]
* [[OLED Display]]
* [[HiLetg Bi-Directional DC Current Power Supply Sensor - INA219 I2C]]
* [[IoT - LiPo Fuel Gauge MAX17043]]

=== Simulators ===

* [https://wokwi.com/ Wokwi - An online Microcontroller IDE and Simulator]

=== I2C - (Inter-Integrated Circuit) / TWI (Two-wire Interface ===
* [[I2C]]

=== Wifi ===
* [[Wifi]]

=== ELK ===
* [[ELK]]

=== LoRa ===
* [[LoRa]]

=== Mac - USB to Serial ===

* [https://github.com/Xinyuan-LilyGO/CH9102_Mac_Driver/blob/main/CH34X_DRV_INSTALL_INSTRUCTIONS.pdf CH34X USB-to_Serial MocOS Driver]
* [https://forums.raspberrypi.com/viewtopic.php?t=301092 Serial Communication To Mac over USB]

=== YouTube ===

* [https://www.youtube.com/c/VolosProjects Volos Projects]

=== Articles ===

* [https://sixfab.com/raspberry-pi-vs-arduino-which-is-better-for-iot-projects/?utm_medium=ppc&utm_campaign=Performance+Max+%7C+US&utm_term=&utm_source=adwords&hsa_src=x&hsa_net=adwords&hsa_kw=&hsa_tgt=&hsa_ad=&hsa_grp=&hsa_mt=&hsa_acc=6308888758&hsa_ver=3&hsa_cam=15788293172&gclid=CjwKCAjw4JWZBhApEiwAtJUN0BVBFj1U2bPc3rv6rWSFiPLtk7vMvRjpIEOJfPKhklcEnmz9hqAyoxoCkXwQAvD_BwE Raspberry Pi vs. Arduino]
* [https://www.tomshardware.com/news/raspberry-pi-rp2040-esp32-together LilyGO T-PicoC3 Combines RP2040 and ESP32 in a Single Board]
* [https://projects.raspberrypi.org/en/projects/getting-started-with-the-pico Intro to Raspberry Pi]
* [https://www.youtube.com/watch?v=OZoi3eChwHw How to setup Raspberry Pi Pico on a Mac]
* [https://www.thebackshed.com/forum/ViewTopic.php?FID=16&TID=14856 T-PicoC3 display works great, pros and cons]
* [https://www.instructables.com/Setup-JetBrains-Clion-for-Arduino-Development/ Setup JetBrains Clion for Arduino Development]
* [https://blog.jetbrains.com/clion/2020/08/arduino-from-hobby-to-prof-p1/ Arduino Development with CLion: From Hobby to Professional Project. Part I]
* [https://learn.sparkfun.com/tutorials/i2c/all Inter-Integrated Circuit (I2C) Protocol]
* [https://github.com/HomeSpan/HomeSpan Apple Homekit for ESP32]
[[index.php?title=Category:IoT]]

Fun

2025-04-05T22:40:23Z

Gregpaskal:

{{: Header_Nav}}

== Online Games ==
[https://www.masswerk.at/spacewar/ SpaceWar1]

[https://spacewar.oversigma.com/ SpaceWar2]

[https://stargate.missionwares.com/ StarGate]

Hardware - Screws

2025-04-05T22:37:07Z

Gregpaskal:

{{: Header_Nav}}

Helpful References when needing to purchase screws.

[[File:Screw-anatomy.png|frameless|left|Anatomy of a screw]]

[[File:Screw Head Types.png|frameless|left|Screw Head Types]]

[[File:Heads.png|frameless|left|Other screw head types]]

Hardware - Screws

2025-04-05T22:34:44Z

Gregpaskal:

{{: Header_Nav}}

Helpful References when needing to purchase screws.

The anatomy of a screw

[[File:Screw-anatomy.png|frameless|left]]

Screw Head Types

[[File:Screw Head Types.png|frameless|left]]

Other screw head types

[[File:Heads.png|frameless|left]]

Hardware - Screws

2025-04-05T22:34:34Z

Gregpaskal:

Hardware - Screws

2025-04-05T22:34:06Z

Gregpaskal:

Hardware - Screws

2025-04-05T22:33:48Z

Gregpaskal:

{{: Header_Nav}}

Helpful References when needing to purchase screws.

The anatomy of a screw
[[File:Screw-anatomy.png|frameless|left]]

Screw Head Types
[[File:Screw Head Types.png|frameless|left]]

Other screw head types
[[File:Heads.png|frameless|left]]

Hardware - Screws

2025-04-05T22:32:39Z

Gregpaskal:

{{: Header_Nav}}

Helpful References when needing to purchase screws.

The anatomy of a screw
[[File:Screw-anatomy.png|frameless|left]]

Screw Head Types
[[File:Screw Head Types.png|frameless|left]]

[[File:Heads.png|frameless|left]]

File:Heads.png

2025-04-05T22:32:29Z

Gregpaskal:

Other details to screw heads

File:Screw Head Types.png

2025-04-05T22:31:06Z

Gregpaskal:

Screw head types

Hardware - Screws

2025-04-05T22:29:47Z

Gregpaskal: Created page with "{{: Header_Nav}} Helpful References when needing to purchase screws. The anatomy of a screw left"

{{: Header_Nav}}

Helpful References when needing to purchase screws.

The anatomy of a screw
[[File:Screw-anatomy.png|frameless|left]]

File:Screw-anatomy.png

2025-04-05T22:29:24Z

Gregpaskal:

These are the various parts of a screw

References

2025-04-05T22:26:31Z

Gregpaskal:

{{: Header_Nav}}
Helpful References to information

*[https://developer.apple.com/documentation/ Apple Developer Documentation]
*[https://developer.atlassian.com/cloud/trello/guides/rest-api/api-introduction/ Great Documentation Example]
*[https://www.dropbox.com/s/g8j8zoervp5jduo/PKM%20-%20MT%20Speaker%20Series%20-%20Robert%20Greiner.pdf?dl=0 Personal Knowledge Management (PKM)]
*[[What's an API]]
*[[HTML - Anatomy]]
*[[Git - Commands]]
*[[Hardware - Screws]]

Testing

2025-04-05T14:29:03Z

Gregpaskal:

{{: Header_Nav}}
This section is all about Testing.

*[[Manual]]
*[[Automation]]
*[[Automation - N-Curve Effect]]
*[[Reference - XPath and Locators]]
*[[Security]]

Main Page

2025-04-05T13:10:51Z

Gregpaskal:

{{: Header_Nav}}

== Welcome ==
Welcome to the CraftOfTesting wiki #2 where I share some of my best tools and practices in Testing, Automation and Innovating. I add frequently here so check back often to see what new and what can help you to in your craft as a technologist.

== Latest additions ==
{{Special:Newestpages/-/10}}