Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current Restore this Version View Page History

« Previous Version 8 Next »

1.Overview

Superset is an open-source modern data exploration and visualization platform.

Link: https://insight.galaxyedu.io/superset/welcome/

2. How to build dashboard

Step 1: Query to get data → Save dataset

  1. Choose database, schema
  2. Write code SQL to get data
  3. Run to check your result
  4. Click button beside "Save"
  5. Save dataset
  6. Save as new or Overwrite existing

Database

Schema

Description

CORE

icanid

merchant, users

icanpayment

bank transfer, billing, transaction

subscription

Product plan

ICAN Kid

icankid

Link

Report

user_report

cash in, paid user 4 BUs


Step 2: Create dashboard

Step 3: Create new chart

  1. Choose a dataset (step 1)
  2. Choose chart type
  3. Click button Create New chart
  4. Add the name of chart, select time range, metrics, filters,...
  5. Save

Step 4: Edit dashboard

  1. Click button Edit dashboard
  2. Drag and drop to edit chart size and position
  3. Discard or Save your chart.

Step 5: Share

Share the dashboard by generating a public or private URL, or embed it in other web applications.

3. Dashboard

3.1. View

3.1.1. Choose dashboard

3.1.2. Filter


3.1.3. View query

3.1.4. Download data from chart

3.2. Edit

3.3. Create

4. Chart

4.1. View

4.1.1. Choose chart

4.1.2. Filter

Note: Please do not save if you only want to view the chart.

4.2. Create

5. Query




Database

Schema

Description

CORE

icanid

merchant, users

icanpayment

bank transfer, billing, transaction

subscription

Product plan

ICAN Kid

icankid

Link

Report

user_report

cash in, paid user 4 BUs