# How to create the Scatter Plot by Graph Panel

**URL:** <https://forum.wise-paas.advantech.com/t/how-to-create-the-scatter-plot-by-graph-panel/1624>\
**Category:** SaaSComposer\
**Created:** [September 12, 2025, 3:38am UTC](https://forum.wise-paas.advantech.com/t/how-to-create-the-scatter-plot-by-graph-panel/1624 "2025-09-12T03:38:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elina\_Liu](https://avatars.discourse-cdn.com/v4/letter/e/43a26b/32.png) [@Elina\_Liu](https://forum.wise-paas.advantech.com/u/Elina_Liu)\
**Post date:** [September 12, 2025, 3:38am UTC](https://forum.wise-paas.advantech.com/t/how-to-create-the-scatter-plot-by-graph-panel/1624/1 "2025-09-12T03:38:06Z")

</div>

![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/9403d2215ed6daa362d6d4d91c4776e8e2c292a0.png)

This tutorial demonstrates how to create Scatter Plot by Graph Panel using two different data sources: **PostgreSQL datasource** and **DataInsight datasource**.

**Dashboard Version: Version 3.0.32**

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/072e6ce26f660781c0e61112fc91c7bfe0f733bf.png)

This table represents counts of different bird species with timestamps:

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/c68bc6eff595def0b07c85034dafc22201b862a6.png)

**Case 1: From PostgreSQL datasource**

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/b41d06e5a41cb72f7f8ca54d34c39e9acb0abd42.png)

```auto
# SQL Query

SELECT 
  UNNEST(ARRAY[
    to_timestamp('2025-09-08 10:00:00', 'YYYY-MM-DD HH24:MI:SS'),
    to_timestamp('2025-09-09 16:00:00', 'YYYY-MM-DD HH24:MI:SS'),
    to_timestamp('2025-09-10 18:00:00', 'YYYY-MM-DD HH24:MI:SS'),
    to_timestamp('2025-09-11 18:00:00', 'YYYY-MM-DD HH24:MI:SS'),
    to_timestamp('2025-09-12 18:00:00', 'YYYY-MM-DD HH24:MI:SS')
  ]) AS "time",
  UNNEST(ARRAY[7, 9, 22, 18, NULL]) AS "Kiwi",
  UNNEST(ARRAY[12, 15, NULL, 25, 20]) AS "Kea",
  UNNEST(ARRAY[5, 8, 17, NULL, 22]) AS "Tui",
  UNNEST(ARRAY[20, NULL, 25, 30, 35]) AS "Morepork",
  UNNEST(ARRAY[25, 18, 30, 28, NULL]) AS "Bellbird"

```

**Case 2: From DataInsight datasource**

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/134d9dface3fa60fa93a8427d02fe5290d8a7c41.png)

```auto
# SQL Query

SELECT 
    (unix_timestamp('2023-08-10 10:00:00', 'yyyy-MM-dd HH:mm:ss') - 8 * 3600) * 1000 AS time,
    5 AS `Taiwan Hwamei`,
    10 AS `Common Kingfisher`,
    2 AS `Taiwan Scimitar Babbler`,
    36 AS `Taiwan Bush Warbler`,
    39 AS `Styan's Bulbul`,
    40 AS `Crested Bunting`

UNION ALL

SELECT
    (unix_timestamp('2023-08-11 16:00:00', 'yyyy-MM-dd HH:mm:ss') - 8 * 3600) * 1000,
    13,
    NULL,
    10,
    NULL,
    NULL,
    NULL

UNION ALL

SELECT
    (unix_timestamp('2023-08-12 18:00:00', 'yyyy-MM-dd HH:mm:ss') - 8 * 3600) * 1000,
    49,
    15,
    NULL,
    10,
    52,
    7

UNION ALL

SELECT
    (unix_timestamp('2023-08-13 18:00:00', 'yyyy-MM-dd HH:mm:ss') - 8 * 3600) * 1000,
    NULL,
    NULL,
    80,
    67,
    35,
    87

UNION ALL

SELECT
    (unix_timestamp('2023-08-14 18:00:00', 'yyyy-MM-dd HH:mm:ss') - 8 * 3600) * 1000,
    NULL,
    30,
    70,
    NULL,
    NULL,
    NULL

```

**Graph Panel Settings**

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/51fc47407cbc48cf6b3323770935ecc9a9ef18d2.png)

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/wisepaasforum/original/1X/ba4acae593e37f325eedf9a0dcfeb8c9cd4d5d98.png)