Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search
Linked Applications
Loading…
Galaxy Education Confluence
Spaces
Create
Create
Hit enter to search
Help
Online Help
Keyboard Shortcuts
Feed Builder
What’s new
Available Gadgets
About Confluence
Log in
Sign up
Galaxy Education
Pages
Galaxy Education
Copy Page
search
attachments
weblink
advanced
image-effects
image-attributes
Paragraph
Paragraph
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Preformatted
Quote
Bold
Italic
Underline
Colour picker
More colours
Formatting
Strikethrough
Subscript
Superscript
Monospace
Clear formatting
Bullet list
Numbered list
Task list
Outdent
Indent
Align left
Align center
Align right
Page layout
Link
Table
Insert
Insert content
Files and images
Link
Markup
Horizontal rule
Task list
Date
Emoticon
Symbol
Insert macro
User mention
Jira Issue/Filter
Info
Status
Gallery
Table of Contents
Other macros
Page layout
No layout
Two column (simple)
Two column (simple, left sidebar)
Two column (simple, right sidebar)
Three column (simple)
Two column
Two column (left sidebar)
Two column (right sidebar)
Three column
Three column (left and right sidebars)
Undo
Redo
Find/Replace
Keyboard shortcuts help
You are not logged in. Any changes you make will be marked as
anonymous
. You may want to
Log In
if you already have an account.
This page is also being edited by
. Your changes will be merged with theirs when you save.
Draft
<h1><strong><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e3RvY30&locale=en_GB&version=2" data-macro-name="toc" data-macro-id="37d1fbfa-f5b4-42cd-a893-28bdc034d973" data-macro-schema-version="1"></strong><strong>1.Overview</strong></h1><p><span>Superset is an open-source modern data exploration and visualization platform.</span></p><p><span>Link: </span><a href="https://insight.galaxyedu.io/superset/welcome/"><span>https://insight.galaxyedu.io/superset/welcome/</span></a></p><p><span><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 09.17.15.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMDkuMTcuMTUucG5nIiAvPg=="></span></p><h1><strong>2. How to build dashboard</strong></h1><h2><strong>Step 1: Query to get data → Save dataset</strong></h2><ol><li>Choose database, schema</li><li>Write code SQL to get data</li><li>Run to check your result</li><li>Click button beside "Save"</li><li>Save dataset</li><li>Save as new or Overwrite existing</li></ol><table class="confluenceTable"><colgroup><col style="width: 86.0px;" /><col style="width: 104.0px;" /><col style="width: 232.0px;" /></colgroup><tbody><tr><td class="confluenceTd"><p><strong>Database</strong></p></td><td class="confluenceTd"><p><strong>Schema</strong></p></td><td class="confluenceTd"><p><strong>Description</strong></p></td></tr><tr><td rowspan="3" class="confluenceTd"><p><span>CORE</span></p></td><td class="confluenceTd"><p><span>icanid</span></p></td><td class="confluenceTd"><p><span>merchant, users</span></p></td></tr><tr><td class="confluenceTd"><p><span>icanpayment</span></p></td><td class="confluenceTd"><p><span>bank transfer, billing, transaction</span></p></td></tr><tr><td class="confluenceTd"><p><span>subscription</span></p></td><td class="confluenceTd"><p><span>Product plan</span></p></td></tr><tr><td class="confluenceTd"><p><span>ICAN Kid</span></p></td><td class="confluenceTd"><p><span>icankid</span></p></td><td class="confluenceTd"><p><a href="https://drive.google.com/file/d/1mmT2W5_j2_mtBmFiEQYjm6ig5eJHTCuw/view?usp=sharing"><span>Link</span></a></p></td></tr><tr><td class="confluenceTd"><p><span>Report</span></p></td><td class="confluenceTd"><p><span>user_report</span></p></td><td class="confluenceTd"><p><span>cash in, paid user 4 BUs</span></p></td></tr></tbody></table><p><br /></p><p><strong><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-05 at 15.39.29.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDUgYXQgMTUuMzkuMjkucG5nIiAvPg=="><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-05 at 15.45.04.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDUgYXQgMTUuNDUuMDQucG5nIiAvPg=="></strong></p><h2><strong>Step 2: Create dashboard</strong></h2><p><strong><span><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.29.18.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMjkuMTgucG5nIiAvPg=="></span><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-05 at 15.51.58.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDUgYXQgMTUuNTEuNTgucG5nIiAvPg=="></strong></p><h2><strong>Step 3: Create new chart</strong></h2><ol><li>Choose a dataset (step 1)</li><li>Choose chart type</li><li>Click button Create New chart</li><li>Add the name of chart, select time range, metrics, filters,...</li><li>Save</li></ol><p><strong><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-05 at 16.03.04.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDUgYXQgMTYuMDMuMDQucG5nIiAvPg=="><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.25.01.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMjUuMDEucG5nIiAvPg=="></strong></p><h2><strong>Step 4: Edit dashboard</strong></h2><ol><li>Click button Edit dashboard</li><li>Drag and drop to edit chart size and position</li><li>Discard or Save your chart.</li></ol><h2><strong>Step 5: Share</strong></h2><p><span style="color: rgb(55,65,81);">Share the dashboard by generating a public or private URL, or embed it in other web applications.</span></p><h1><strong>3. Dashboard</strong></h1><h2><strong>3.1. View</strong></h2><h3><span>3.1.1. Choose dashboard</span></h3><p><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 09.18.57.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMDkuMTguNTcucG5nIiAvPg=="></p><h3><span>3.1.2. Filter</span></h3><p><br /></p><p><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 09.30.59.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMDkuMzAuNTkucG5nIiAvPg=="></p><h3><span>3.1.3. View query</span></h3><p><span><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 09.41.13.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMDkuNDEuMTMucG5nIiAvPg=="></span></p><h3><span>3.1.4. Download data from chart</span></h3><p><span><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.35.24.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMzUuMjQucG5nIiAvPg=="></span></p><h2><strong>3.2. Edit</strong></h2><p><span><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 09.48.45.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMDkuNDguNDUucG5nIiAvPg=="><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 09.51.13.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMDkuNTEuMTMucG5nIiAvPg=="></span></p><h2><strong>3.3. Create</strong></h2><p><span><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.29.18.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMjkuMTgucG5nIiAvPg=="><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.31.32.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMzEuMzIucG5nIiAvPg=="></span></p><h1><strong>4. Chart</strong></h1><h2><strong>4.1. View</strong></h2><h3><span>4.1.1. Choose chart</span></h3><p><span><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.02.12.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMDIuMTIucG5nIiAvPg=="></span></p><h3><span>4.1.2. Filter</span></h3><p><span><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.06.55.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMDYuNTUucG5nIiAvPg=="><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.11.21.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMTEuMjEucG5nIiAvPg=="></span></p><p><span><strong>Note</strong>: </span><span>Please do not save if you only want to view the chart.</span></p><h2><span>4.2. Create</span></h2><p><span><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.17.55.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMTcuNTUucG5nIiAvPg=="><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.20.46.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMjAuNDYucG5nIiAvPg=="><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.25.01.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuMjUuMDEucG5nIiAvPg=="></span></p><h1><strong>5. Query</strong></h1><p><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.42.07.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuNDIuMDcucG5nIiAvPg=="><br /><br /></p><p><img class="confluence-embedded-image" src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screen Shot 2023-10-04 at 10.45.24.png" data-resource-id="PHJpOmF0dGFjaG1lbnQgcmk6ZmlsZW5hbWU9IlNjcmVlbiBTaG90IDIwMjMtMTAtMDQgYXQgMTAuNDUuMjQucG5nIiAvPg=="></p><p><br /></p><table class="wrapped confluenceTable"><colgroup><col /><col /><col /></colgroup><tbody><tr><td class="confluenceTd"><p><strong>Database</strong></p></td><td class="confluenceTd"><p><strong>Schema</strong></p></td><td class="confluenceTd"><p><strong>Description</strong></p></td></tr><tr><td rowspan="3" class="confluenceTd"><p><span>CORE</span></p></td><td class="confluenceTd"><p><span>icanid</span></p></td><td class="confluenceTd"><p><span>merchant, users</span></p></td></tr><tr><td class="confluenceTd"><p><span>icanpayment</span></p></td><td class="confluenceTd"><p><span>bank transfer, billing, transaction</span></p></td></tr><tr><td class="confluenceTd"><p><span>subscription</span></p></td><td class="confluenceTd"><p><span>Product plan</span></p></td></tr><tr><td class="confluenceTd"><p><span>ICAN Kid</span></p></td><td class="confluenceTd"><p><span>icankid</span></p></td><td class="confluenceTd"><p><a href="https://drive.google.com/file/d/1mmT2W5_j2_mtBmFiEQYjm6ig5eJHTCuw/view?usp=sharing"><span>Link</span></a></p></td></tr><tr><td class="confluenceTd"><p><span>Report</span></p></td><td class="confluenceTd"><p><span>user_report</span></p></td><td class="confluenceTd"><p><span>cash in, paid user 4 BUs</span></p></td></tr></tbody></table><p class="auto-cursor-target"><br /></p>
If you are unable to use this CAPTCHA please <a href="administrators.action" tabindex="5">contact your administrator</a> for assistance.
Edit
Save
Close
Preview
Delete unpublished page
{"serverDuration": 225, "requestCorrelationId": "5b2025a55859d15e"}