Google Git
Sign in
apache / superset-site / 514b6439e2b69393a8fdc13de5f2006bdcf329fa / . / docs / 6.0.0 / using-superset / creating-your-first-dashboard / index.html
blob: 0c52e741eb74d312916c8bbf04c1f2a165f03df4 [file] [log] [blame]
<!doctype html>
<html lang="en" dir="ltr" class="docs-wrapper plugin-docs plugin-id-default docs-version-6.0.0 docs-doc-page docs-doc-id-using-superset/creating-your-first-dashboard" data-has-hydrated="false">
<head>
<meta charset="UTF-8">
<meta name="generator" content="Docusaurus v3.8.1">
<title data-rh="true">Creating Your First Dashboard | Superset</title><meta data-rh="true" name="viewport" content="width=device-width,initial-scale=1"><meta data-rh="true" name="twitter:card" content="summary_large_image"><meta data-rh="true" property="og:url" content="https://superset.apache.org/docs/6.0.0/using-superset/creating-your-first-dashboard"><meta data-rh="true" property="og:locale" content="en"><meta data-rh="true" name="docusaurus_locale" content="en"><meta data-rh="true" name="docsearch:language" content="en"><meta data-rh="true" name="docusaurus_version" content="6.0.0"><meta data-rh="true" name="docusaurus_tag" content="docs-default-6.0.0"><meta data-rh="true" name="docsearch:version" content="6.0.0"><meta data-rh="true" name="docsearch:docusaurus_tag" content="docs-default-6.0.0"><meta data-rh="true" property="og:title" content="Creating Your First Dashboard | Superset"><meta data-rh="true" name="description" content="Creating Your First Dashboard"><meta data-rh="true" property="og:description" content="Creating Your First Dashboard"><link data-rh="true" rel="icon" href="/img/favicon.ico"><link data-rh="true" rel="canonical" href="https://superset.apache.org/docs/6.0.0/using-superset/creating-your-first-dashboard"><link data-rh="true" rel="alternate" href="https://superset.apache.org/docs/6.0.0/using-superset/creating-your-first-dashboard" hreflang="en"><link data-rh="true" rel="alternate" href="https://superset.apache.org/docs/6.0.0/using-superset/creating-your-first-dashboard" hreflang="x-default"><link data-rh="true" rel="preconnect" href="https://WR5FASX5ED-dsn.algolia.net" crossorigin="anonymous"><script data-rh="true" type="application/ld+json">{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Creating Your First Dashboard","item":"https://superset.apache.org/docs/6.0.0/using-superset/creating-your-first-dashboard"}]}</script><link rel="search" type="application/opensearchdescription+xml" title="Superset" href="/opensearch.xml">
<script src="https://widget.kapa.ai/kapa-widget.bundle.js" async data-website-id="c6a8a8b8-3127-48f9-97a7-51e9e10d20d0" data-project-name="Apache Superset" data-project-color="#FFFFFF" data-project-logo="https://images.seeklogo.com/logo-png/50/2/superset-icon-logo-png_seeklogo-500354.png" data-modal-override-open-id="ask-ai-input" data-modal-override-open-class="search-input" data-modal-disclaimer="This is a custom LLM for Apache Superset with access to all [documentation](superset.apache.org/docs/intro/), [GitHub Open Issues, PRs and READMEs](github.com/apache/superset).&amp;#10;&amp;#10;Companies deploy assistants like this ([built by kapa.ai](https://kapa.ai)) on docs via [website widget](https://docs.kapa.ai/integrations/website-widget) (Docker, Reddit), in [support forms](https://docs.kapa.ai/integrations/support-form-deflector) for ticket deflection (Monday.com, Mapbox), or as [Slack bots](https://docs.kapa.ai/integrations/slack-bot) with private sources." data-modal-example-questions="How do I install Superset?,How can I contribute to Superset?" data-button-text-color="rgb(81,166,197)" data-modal-header-bg-color="#ffffff" data-modal-title-color="rgb(81,166,197)" data-modal-title="Apache Superset AI" data-modal-disclaimer-text-color="#000000" data-consent-required="true" data-consent-screen-disclaimer="By clicking &quot;I agree, let&#39;s chat&quot;, you consent to the use of the AI assistant in accordance with kapa.ai&#39;s [Privacy Policy](https://www.kapa.ai/content/privacy-policy). This service uses reCAPTCHA, which requires your consent to Google&#39;s [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms). By proceeding, you explicitly agree to both kapa.ai&#39;s and Google&#39;s privacy policies."></script><link rel="stylesheet" href="/assets/css/styles.f7e4fcdd.css">
<script src="/assets/js/runtime~main.f4273838.js" defer="defer"></script>
<script src="/assets/js/main.e65baf75.js" defer="defer"></script>
</head>
<body class="navigation-with-keyboard">
<svg xmlns="http://www.w3.org/2000/svg" style="display: none;"><defs>
<symbol id="theme-svg-external-link" viewBox="0 0 24 24"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"/></symbol>
</defs></svg>
<script>!function(){var t=function(){try{return new URLSearchParams(window.location.search).get("docusaurus-theme")}catch(t){}}()||function(){try{return window.localStorage.getItem("theme")}catch(t){}}();document.documentElement.setAttribute("data-theme",t||(window.matchMedia("(prefers-color-scheme: dark)").matches?"dark":"light")),document.documentElement.setAttribute("data-theme-choice",t||"system")}(),function(){try{const c=new URLSearchParams(window.location.search).entries();for(var[t,e]of c)if(t.startsWith("docusaurus-data-")){var a=t.replace("docusaurus-data-","data-");document.documentElement.setAttribute(a,e)}}catch(t){}}()</script><div id="__docusaurus"><div role="region" aria-label="Skip to main content"><a class="skipToContent_fXgn" href="#__docusaurus_skipToContent_fallback">Skip to main content</a></div><nav aria-label="Main" class="theme-layout-navbar navbar navbar--fixed-top"><div class="navbar__inner"><div class="theme-layout-navbar-left navbar__items"><button aria-label="Toggle navigation bar" aria-expanded="false" class="navbar__toggle clean-btn" type="button"><svg width="30" height="30" viewBox="0 0 30 30" aria-hidden="true"><path stroke="currentColor" stroke-linecap="round" stroke-miterlimit="10" stroke-width="2" d="M4 7h22M4 15h22M4 23h22"></path></svg></button><a class="navbar__brand" href="/"><div class="navbar__logo"><img src="/img/superset-logo-horiz.svg" alt="Superset Logo" class="themedComponent_mlkZ themedComponent--light_NVdE"><img src="/img/superset-logo-horiz-dark.svg" alt="Superset Logo" class="themedComponent_mlkZ themedComponent--dark_xIcU"></div></a><div class="navbar__item dropdown dropdown--hoverable"><a href="#" aria-haspopup="true" aria-expanded="false" role="button" class="navbar__link">Documentation</a><ul class="dropdown__menu"><li><a aria-current="page" class="dropdown__link dropdown__link--active" href="/docs/6.0.0/intro">Getting Started</a></li><li><a aria-current="page" class="dropdown__link dropdown__link--active" href="/docs/6.0.0/faq">FAQ</a></li></ul></div><div class="navbar__item dropdown dropdown--hoverable"><a class="navbar__link" aria-haspopup="true" aria-expanded="false" role="button" href="/community">Community Resources</a><ul class="dropdown__menu"><li><a class="dropdown__link" href="/community">Resources</a></li><li><a href="https://github.com/apache/superset" target="_blank" rel="noopener noreferrer" class="dropdown__link">GitHub<svg width="12" height="12" aria-hidden="true" class="iconExternalLink_nPIU"><use href="#theme-svg-external-link"></use></svg></a></li><li><a href="http://bit.ly/join-superset-slack" target="_blank" rel="noopener noreferrer" class="dropdown__link">Slack<svg width="12" height="12" aria-hidden="true" class="iconExternalLink_nPIU"><use href="#theme-svg-external-link"></use></svg></a></li><li><a href="https://lists.apache.org/list.html?dev@superset.apache.org" target="_blank" rel="noopener noreferrer" class="dropdown__link">Mailing List<svg width="12" height="12" aria-hidden="true" class="iconExternalLink_nPIU"><use href="#theme-svg-external-link"></use></svg></a></li><li><a href="https://stackoverflow.com/questions/tagged/apache-superset" target="_blank" rel="noopener noreferrer" class="dropdown__link">Stack Overflow<svg width="12" height="12" aria-hidden="true" class="iconExternalLink_nPIU"><use href="#theme-svg-external-link"></use></svg></a></li></ul></div></div><div class="theme-layout-navbar-right navbar__items navbar__items--right"><a class="navbar__item navbar__link default-button-theme get-started-button" href="/docs/intro">Get Started</a><a href="https://github.com/apache/superset" target="_blank" rel="noopener noreferrer" class="navbar__item navbar__link github-button"></a><div class="toggle_vylO colorModeToggle_DEke"><button class="clean-btn toggleButton_gllP toggleButtonDisabled_aARS" type="button" disabled="" title="system mode" aria-label="Switch between dark and light mode (currently system mode)"><svg viewBox="0 0 24 24" width="24" height="24" aria-hidden="true" class="toggleIcon_g3eP lightToggleIcon_pyhR"><path fill="currentColor" d="M12,9c1.65,0,3,1.35,3,3s-1.35,3-3,3s-3-1.35-3-3S10.35,9,12,9 M12,7c-2.76,0-5,2.24-5,5s2.24,5,5,5s5-2.24,5-5 S14.76,7,12,7L12,7z M2,13l2,0c0.55,0,1-0.45,1-1s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S1.45,13,2,13z M20,13l2,0c0.55,0,1-0.45,1-1 s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S19.45,13,20,13z M11,2v2c0,0.55,0.45,1,1,1s1-0.45,1-1V2c0-0.55-0.45-1-1-1S11,1.45,11,2z M11,20v2c0,0.55,0.45,1,1,1s1-0.45,1-1v-2c0-0.55-0.45-1-1-1C11.45,19,11,19.45,11,20z M5.99,4.58c-0.39-0.39-1.03-0.39-1.41,0 c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0s0.39-1.03,0-1.41L5.99,4.58z M18.36,16.95 c-0.39-0.39-1.03-0.39-1.41,0c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0c0.39-0.39,0.39-1.03,0-1.41 L18.36,16.95z M19.42,5.99c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06c-0.39,0.39-0.39,1.03,0,1.41 s1.03,0.39,1.41,0L19.42,5.99z M7.05,18.36c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06 c-0.39,0.39-0.39,1.03,0,1.41s1.03,0.39,1.41,0L7.05,18.36z"></path></svg><svg viewBox="0 0 24 24" width="24" height="24" aria-hidden="true" class="toggleIcon_g3eP darkToggleIcon_wfgR"><path fill="currentColor" d="M9.37,5.51C9.19,6.15,9.1,6.82,9.1,7.5c0,4.08,3.32,7.4,7.4,7.4c0.68,0,1.35-0.09,1.99-0.27C17.45,17.19,14.93,19,12,19 c-3.86,0-7-3.14-7-7C5,9.07,6.81,6.55,9.37,5.51z M12,3c-4.97,0-9,4.03-9,9s4.03,9,9,9s9-4.03,9-9c0-0.46-0.04-0.92-0.1-1.36 c-0.98,1.37-2.58,2.26-4.4,2.26c-2.98,0-5.4-2.42-5.4-5.4c0-1.81,0.89-3.42,2.26-4.4C12.92,3.04,12.46,3,12,3L12,3z"></path></svg><svg viewBox="0 0 24 24" width="24" height="24" aria-hidden="true" class="toggleIcon_g3eP systemToggleIcon_QzmC"><path fill="currentColor" d="m12 21c4.971 0 9-4.029 9-9s-4.029-9-9-9-9 4.029-9 9 4.029 9 9 9zm4.95-13.95c1.313 1.313 2.05 3.093 2.05 4.95s-0.738 3.637-2.05 4.95c-1.313 1.313-3.093 2.05-4.95 2.05v-14c1.857 0 3.637 0.737 4.95 2.05z"></path></svg></button></div><div class="navbarSearchContainer_Bca1"><button type="button" class="DocSearch DocSearch-Button" aria-label="Search (Command+K)"><span class="DocSearch-Button-Container"><svg width="20" height="20" class="DocSearch-Search-Icon" viewBox="0 0 20 20" aria-hidden="true"><path d="M14.386 14.386l4.0877 4.0877-4.0877-4.0877c-2.9418 2.9419-7.7115 2.9419-10.6533 0-2.9419-2.9418-2.9419-7.7115 0-10.6533 2.9418-2.9419 7.7115-2.9419 10.6533 0 2.9419 2.9418 2.9419 7.7115 0 10.6533z" stroke="currentColor" fill="none" fill-rule="evenodd" stroke-linecap="round" stroke-linejoin="round"></path></svg><span class="DocSearch-Button-Placeholder">Search</span></span><span class="DocSearch-Button-Keys"></span></button></div></div></div><div role="presentation" class="navbar-sidebar__backdrop"></div></nav><div id="__docusaurus_skipToContent_fallback" class="theme-layout-main main-wrapper mainWrapper_z2l0"><div class="docsWrapper_hBAB"><button aria-label="Scroll back to top" class="clean-btn theme-back-to-top-button backToTopButton_sjWU" type="button"></button><div class="docRoot_UBD9"><aside class="theme-doc-sidebar-container docSidebarContainer_YfHR"><div class="sidebarViewport_aRkj"><div class="sidebar_njMd"><nav aria-label="Docs sidebar" class="menu thin-scrollbar menu_SIkG"><ul class="theme-doc-sidebar-menu menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/docs/6.0.0/intro">Introduction</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/docs/6.0.0/quickstart">Quickstart</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" href="/docs/6.0.0/installation/architecture">Installation</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" href="/docs/6.0.0/configuration/configuring-superset">Configuration</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret menu__link--active" role="button" aria-expanded="true" href="/docs/6.0.0/using-superset/creating-your-first-dashboard">Using Superset</a></div><ul class="menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link menu__link--active" aria-current="page" tabindex="0" href="/docs/6.0.0/using-superset/creating-your-first-dashboard">Creating Your First Dashboard</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/6.0.0/using-superset/exploring-data">Exploring Data in Superset</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/6.0.0/using-superset/issue-codes">Issue Codes</a></li></ul></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" href="/docs/6.0.0/contributing/">Contributing</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" role="button" aria-expanded="false" href="/docs/6.0.0/security/">Security</a></div></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/docs/6.0.0/faq">FAQ</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/docs/6.0.0/api">API</a></li></ul></nav><button type="button" title="Collapse sidebar" aria-label="Collapse sidebar" class="button button--secondary button--outline collapseSidebarButton_PEFL"><svg width="20" height="20" aria-hidden="true" class="collapseSidebarButtonIcon_kv0_"><g fill="#7a7a7a"><path d="M9.992 10.023c0 .2-.062.399-.172.547l-4.996 7.492a.982.982 0 01-.828.454H1c-.55 0-1-.453-1-1 0-.2.059-.403.168-.551l4.629-6.942L.168 3.078A.939.939 0 010 2.528c0-.548.45-.997 1-.997h2.996c.352 0 .649.18.828.45L9.82 9.472c.11.148.172.347.172.55zm0 0"></path><path d="M19.98 10.023c0 .2-.058.399-.168.547l-4.996 7.492a.987.987 0 01-.828.454h-3c-.547 0-.996-.453-.996-1 0-.2.059-.403.168-.551l4.625-6.942-4.625-6.945a.939.939 0 01-.168-.55 1 1 0 01.996-.997h3c.348 0 .649.18.828.45l4.996 7.492c.11.148.168.347.168.55zm0 0"></path></g></svg></button></div></div></aside><main class="docMainContainer_TBSr"><div class="container padding-top--md padding-bottom--lg"><div class="row"><div class="col docItemCol_VOVn"><div class="docItemContainer_Djhp"><article><nav class="theme-doc-breadcrumbs breadcrumbsContainer_Z_bl" aria-label="Breadcrumbs"><ul class="breadcrumbs"><li class="breadcrumbs__item"><a aria-label="Home page" class="breadcrumbs__link" href="/"><svg viewBox="0 0 24 24" class="breadcrumbHomeIcon_YNFT"><path d="M10 19v-5h4v5c0 .55.45 1 1 1h3c.55 0 1-.45 1-1v-7h1.7c.46 0 .68-.57.33-.87L12.67 3.6c-.38-.34-.96-.34-1.34 0l-8.36 7.53c-.34.3-.13.87.33.87H5v7c0 .55.45 1 1 1h3c.55 0 1-.45 1-1z" fill="currentColor"></path></svg></a></li><li class="breadcrumbs__item"><span class="breadcrumbs__link">Using Superset</span></li><li class="breadcrumbs__item breadcrumbs__item--active"><span class="breadcrumbs__link">Creating Your First Dashboard</span></li></ul></nav><span class="versionBadge_QOso">Version:<!-- --> <a class="ant-dropdown-trigger versionSelector_oOvN">6.0.0<!-- --> <span role="img" aria-label="down" class="anticon anticon-down"><svg viewBox="64 64 896 896" focusable="false" data-icon="down" width="1em" height="1em" fill="currentColor" aria-hidden="true"><path d="M884 256h-75c-5.1 0-9.9 2.5-12.9 6.6L512 654.2 227.9 262.6c-3-4.1-7.8-6.6-12.9-6.6h-75c-6.5 0-10.3 7.4-6.5 12.7l352.6 486.1c12.8 17.6 39 17.6 51.7 0l352.6-486.1c3.9-5.3.1-12.7-6.4-12.7z"></path></svg></span></a></span><div class="tocCollapsible_ETCw theme-doc-toc-mobile tocMobile_ITEo"><button type="button" class="clean-btn tocCollapsibleButton_TO0P">On this page</button></div><div class="theme-doc-markdown markdown"><h2 class="anchor anchorWithStickyNavbar_LWe7" id="creating-your-first-dashboard">Creating Your First Dashboard<a href="#creating-your-first-dashboard" class="hash-link" aria-label="Direct link to Creating Your First Dashboard" title="Direct link to Creating Your First Dashboard">​</a></h2>
<p>This section is focused on documentation for end-users who will be using Superset
for the data analysis and exploration workflow
(data analysts, business analysts, data
scientists, etc).</p>
<div class="theme-admonition theme-admonition-tip admonition_xJq3 alert alert--success"><div class="admonitionHeading_Gvgb"><span class="admonitionIcon_Rf37"><svg viewBox="0 0 12 16"><path fill-rule="evenodd" d="M6.5 0C3.48 0 1 2.19 1 5c0 .92.55 2.25 1 3 1.34 2.25 1.78 2.78 2 4v1h5v-1c.22-1.22.66-1.75 2-4 .45-.75 1-2.08 1-3 0-2.81-2.48-5-5.5-5zm3.64 7.48c-.25.44-.47.8-.67 1.11-.86 1.41-1.25 2.06-1.45 3.23-.02.05-.02.11-.02.17H5c0-.06 0-.13-.02-.17-.2-1.17-.59-1.83-1.45-3.23-.2-.31-.42-.67-.67-1.11C2.44 6.78 2 5.65 2 5c0-2.2 2.02-4 4.5-4 1.22 0 2.36.42 3.22 1.19C10.55 2.94 11 3.94 11 5c0 .66-.44 1.78-.86 2.48zM4 14h5c-.23 1.14-1.3 2-2.5 2s-2.27-.86-2.5-2z"></path></svg></span>tip</div><div class="admonitionContent_BuS1"><p>In addition to this site, <a href="http://preset.io/" target="_blank" rel="noopener noreferrer">Preset.io</a> maintains an updated set of end-user
documentation at <a href="https://docs.preset.io/" target="_blank" rel="noopener noreferrer">docs.preset.io</a>.</p></div></div>
<p>This tutorial targets someone who wants to create charts and dashboards in Superset. We’ll show you
how to connect Superset to a new database and configure a table in that database for analysis.
You’ll also explore the data you’ve exposed and add a visualization to a dashboard so that you get a
feel for the end-to-end user experience.</p>
<h3 class="anchor anchorWithStickyNavbar_LWe7" id="connecting-to-a-new-database">Connecting to a new database<a href="#connecting-to-a-new-database" class="hash-link" aria-label="Direct link to Connecting to a new database" title="Direct link to Connecting to a new database">​</a></h3>
<p>Superset itself doesn&#x27;t have a storage layer to store your data but instead pairs with
your existing SQL-speaking database or data store.</p>
<p>First things first, we need to add the connection credentials to your database to be able
to query and visualize data from it. If you&#x27;re using Superset locally via
<a href="/docs/installation/docker-compose">Docker compose</a>, you can
skip this step because a Postgres database, named <strong>examples</strong>, is included and
pre-configured in Superset for you.</p>
<p>Under the <strong>+</strong> menu in the top right, select Data, and then the <em>Connect Database</em> option:</p>
<img src="/img/tutorial/tutorial_01_add_database_connection.png" width="600">
<!-- --> <!-- -->
<br>
<br>
<p>Then select your database type in the resulting modal:</p>
<img src="/img/tutorial/tutorial_02_select_database.png" width="600">
<!-- --> <!-- -->
<br>
<br>
<p>Once you&#x27;ve selected a database, you can configure a number of advanced options in this window,
or for the purposes of this walkthrough, you can click the link below all these fields:</p>
<img src="/img/tutorial/tutorial_03a_database_connection_string_link.png" width="600">
<!-- --> <!-- -->
<br>
<br>
<p>Please note, if you are trying to connect to another locally running database (whether on host or another container), and you get the message <code>The port is closed.</code>, then you need to adjust the HOST to <code>host.docker.internal</code></p>
<p>Once you&#x27;ve clicked that link you only need to specify two things (the database name and SQLAlchemy URI):</p>
<img src="/img/tutorial/tutorial_03b_connection_string_details.png" width="600">
<!-- --> <!-- -->
<br>
<br>
<p>As noted in the text below the form, you should refer to the SQLAlchemy documentation on
<a href="https://docs.sqlalchemy.org/en/12/core/engines.html#database-urls" target="_blank" rel="noopener noreferrer">creating new connection URIs</a>
for your target database.</p>
<p>Click the <strong>Test Connection</strong> button to confirm things work end to end. If the connection looks good, save the configuration
by clicking the <strong>Connect</strong> button in the bottom right corner of the modal window:</p>
<p>Congratulations, you&#x27;ve just added a new data source in Superset!</p>
<h3 class="anchor anchorWithStickyNavbar_LWe7" id="registering-a-new-table">Registering a new table<a href="#registering-a-new-table" class="hash-link" aria-label="Direct link to Registering a new table" title="Direct link to Registering a new table">​</a></h3>
<p>Now that you’ve configured a data source, you can select specific tables (called <strong>Datasets</strong> in Superset)
that you want exposed in Superset for querying.</p>
<p>Navigate to <strong>Data ‣ Datasets</strong> and select the <strong>+ Dataset</strong> button in the top right corner.</p>
<img src="/img/tutorial/tutorial_08_sources_tables.png">
<p>A modal window should pop up in front of you. Select your <strong>Database</strong>,
<strong>Schema</strong>, and <strong>Table</strong> using the drop downs that appear. In the following example,
we register the <strong>cleaned_sales_data</strong> table from the <strong>examples</strong> database.</p>
<img src="/img/tutorial/tutorial_09_add_new_table.png">
<p>To finish, click the <strong>Add</strong> button in the bottom right corner. You should now see your dataset in the list of datasets.</p>
<h3 class="anchor anchorWithStickyNavbar_LWe7" id="customizing-column-properties">Customizing column properties<a href="#customizing-column-properties" class="hash-link" aria-label="Direct link to Customizing column properties" title="Direct link to Customizing column properties">​</a></h3>
<p>Now that you&#x27;ve registered your dataset, you can configure column properties
for how the column should be treated in the Explore workflow:</p>
<ul>
<li>Is the column temporal? (should it be used for slicing &amp; dicing in time series charts?)</li>
<li>Should the column be filterable?</li>
<li>Is the column dimensional?</li>
<li>If it&#x27;s a datetime column, how should Superset parse
the datetime format? (using the <a href="https://en.wikipedia.org/wiki/ISO_8601" target="_blank" rel="noopener noreferrer">ISO-8601 string pattern</a>)</li>
</ul>
<img src="/img/tutorial/tutorial_column_properties.png">
<h3 class="anchor anchorWithStickyNavbar_LWe7" id="superset-semantic-layer">Superset semantic layer<a href="#superset-semantic-layer" class="hash-link" aria-label="Direct link to Superset semantic layer" title="Direct link to Superset semantic layer">​</a></h3>
<p>Superset has a thin semantic layer that adds many quality of life improvements for analysts.
The Superset semantic layer can store 2 types of computed data:</p>
<ol>
<li>Virtual metrics: you can write SQL queries that aggregate values
from multiple column (e.g. <code>SUM(recovered) / SUM(confirmed)</code>) and make them
available as columns for (e.g. <code>recovery_rate</code>) visualization in Explore.
Aggregate functions are allowed and encouraged for metrics.</li>
</ol>
<img src="/img/tutorial/tutorial_sql_metric.png">
<p>You can also certify metrics if you&#x27;d like for your team in this view.</p>
<ol>
<li>Virtual calculated columns: you can write SQL queries that
customize the appearance and behavior
of a specific column (e.g. <code>CAST(recovery_rate as float)</code>).
Aggregate functions aren&#x27;t allowed in calculated columns.</li>
</ol>
<img src="/img/tutorial/tutorial_calculated_column.png">
<h3 class="anchor anchorWithStickyNavbar_LWe7" id="creating-charts-in-explore-view">Creating charts in Explore view<a href="#creating-charts-in-explore-view" class="hash-link" aria-label="Direct link to Creating charts in Explore view" title="Direct link to Creating charts in Explore view">​</a></h3>
<p>Superset has 2 main interfaces for exploring data:</p>
<ul>
<li><strong>Explore</strong>: no-code viz builder. Select your dataset, select the chart,
customize the appearance, and publish.</li>
<li><strong>SQL Lab</strong>: SQL IDE for cleaning, joining, and preparing data for Explore workflow</li>
</ul>
<p>We&#x27;ll focus on the Explore view for creating charts right now.
To start the Explore workflow from the <strong>Datasets</strong> tab, start by clicking the name
of the dataset that will be powering your chart.</p>
<img src="/img/tutorial/tutorial_launch_explore.png">
<br>
<br>
<p>You&#x27;re now presented with a powerful workflow for exploring data and iterating on charts.</p>
<ul>
<li>The <strong>Dataset</strong> view on the left-hand side has a list of columns and metrics,
scoped to the current dataset you selected.</li>
<li>The <strong>Data</strong> preview below the chart area also gives you helpful data context.</li>
<li>Using the <strong>Data</strong> tab and <strong>Customize</strong> tabs, you can change the visualization type,
select the temporal column, select the metric to group by, and customize
the aesthetics of the chart.</li>
</ul>
<p>As you customize your chart using drop-down menus, make sure to click the <strong>Run</strong> button
to get visual feedback.</p>
<img src="/img/tutorial/tutorial_explore_run.jpg">
<p>In the following screenshot, we craft a grouped Time-series Bar Chart to visualize
our quarterly sales data by product line just by clicking options in drop-down menus.</p>
<img src="/img/tutorial/tutorial_explore_settings.jpg">
<h3 class="anchor anchorWithStickyNavbar_LWe7" id="creating-a-slice-and-dashboard">Creating a slice and dashboard<a href="#creating-a-slice-and-dashboard" class="hash-link" aria-label="Direct link to Creating a slice and dashboard" title="Direct link to Creating a slice and dashboard">​</a></h3>
<p>To save your chart, first click the <strong>Save</strong> button. You can either:</p>
<ul>
<li>Save your chart and add it to an existing dashboard</li>
<li>Save your chart and add it to a new dashboard</li>
</ul>
<p>In the following screenshot, we save the chart to a new &quot;Superset Duper Sales Dashboard&quot;:</p>
<img src="/img/tutorial/tutorial_save_slice.png">
<p>To publish, click <strong>Save and goto Dashboard</strong>.</p>
<p>Behind the scenes, Superset will create a slice and store all the information needed
to create your chart in its thin data layer
(the query, chart type, options selected, name, etc).</p>
<img src="/img/tutorial/tutorial_first_dashboard.png" style="width:100%;max-width:500px">
<p>To resize the chart, start by clicking the Edit Dashboard button in the top right corner.</p>
<img src="/img/tutorial/tutorial_edit_button.png" width="300">
<p>Then, click and drag the bottom right corner of the chart until the chart layout snaps
into a position you like onto the underlying grid.</p>
<img src="/img/tutorial/tutorial_chart_resize.png" style="width:100%;max-width:500px">
<p>Click <strong>Save</strong> to persist the changes.</p>
<p>Congrats! You’ve successfully linked, analyzed, and visualized data in Superset. There are a wealth
of other table configuration and visualization options, so please start exploring and creating
slices and dashboards of your own.</p>
<h3 class="anchor anchorWithStickyNavbar_LWe7" id="manage-access-to-dashboards">Manage access to Dashboards<a href="#manage-access-to-dashboards" class="hash-link" aria-label="Direct link to Manage access to Dashboards" title="Direct link to Manage access to Dashboards">​</a></h3>
<p>Access to dashboards is managed via owners (users that have edit permissions to the dashboard).</p>
<p>Non-owner users access can be managed in two different ways. The dashboard needs to be published to be visible to other users.</p>
<ol>
<li>Dataset permissions - if you add to the relevant role permissions to datasets it automatically grants implicit access to all dashboards that uses those permitted datasets.</li>
<li>Dashboard roles - if you enable <a href="/docs/configuration/configuring-superset#feature-flags"><strong>DASHBOARD_RBAC</strong> feature flag</a> then you will be able to manage which roles can access the dashboard<!-- -->
<ul>
<li>Granting a role access to a dashboard will bypass dataset level checks. Having dashboard access implicitly grants read access to all the featured charts in the dashboard, and thereby also all the associated datasets.</li>
<li>If no roles are specified for a dashboard, regular <strong>Dataset permissions</strong> will apply.</li>
</ul>
</li>
</ol>
<img src="/img/tutorial/tutorial_dashboard_access.png">
<h3 class="anchor anchorWithStickyNavbar_LWe7" id="publishing-a-dashboard">Publishing a Dashboard<a href="#publishing-a-dashboard" class="hash-link" aria-label="Direct link to Publishing a Dashboard" title="Direct link to Publishing a Dashboard">​</a></h3>
<p>If you would like to make your dashboard available to other users, click on the <code>Draft</code> button next to the
title of your dashboard.</p>
<img src="/img/tutorial/publish_button_dashboard.png">
<div class="theme-admonition theme-admonition-warning admonition_xJq3 alert alert--warning"><div class="admonitionHeading_Gvgb"><span class="admonitionIcon_Rf37"><svg viewBox="0 0 16 16"><path fill-rule="evenodd" d="M8.893 1.5c-.183-.31-.52-.5-.887-.5s-.703.19-.886.5L.138 13.499a.98.98 0 0 0 0 1.001c.193.31.53.501.886.501h13.964c.367 0 .704-.19.877-.5a1.03 1.03 0 0 0 .01-1.002L8.893 1.5zm.133 11.497H6.987v-2.003h2.039v2.003zm0-3.004H6.987V5.987h2.039v4.006z"></path></svg></span>warning</div><div class="admonitionContent_BuS1"><p>Draft dashboards are only visible to the dashboard owners and admins. Published dashboards are visible to all users with access to the underlying datasets or if RBAC is enabled, to the roles that have been granted access to the dashboard.</p></div></div>
<h3 class="anchor anchorWithStickyNavbar_LWe7" id="mark-a-dashboard-as-favorite">Mark a Dashboard as Favorite<a href="#mark-a-dashboard-as-favorite" class="hash-link" aria-label="Direct link to Mark a Dashboard as Favorite" title="Direct link to Mark a Dashboard as Favorite">​</a></h3>
<p>You can mark a dashboard as a favorite by clicking on the star icon next to the title of your dashboard. This makes it easier to find it in the list of dashboards or on the home page.</p>
<h3 class="anchor anchorWithStickyNavbar_LWe7" id="customizing-dashboard">Customizing dashboard<a href="#customizing-dashboard" class="hash-link" aria-label="Direct link to Customizing dashboard" title="Direct link to Customizing dashboard">​</a></h3>
<p>The following URL parameters can be used to modify how the dashboard is rendered:</p>
<ul>
<li><code>standalone</code>:<!-- -->
<ul>
<li><code>0</code> (default): dashboard is displayed normally</li>
<li><code>1</code>: Top Navigation is hidden</li>
<li><code>2</code>: Top Navigation + title is hidden</li>
<li><code>3</code>: Top Navigation + title + top level tabs are hidden</li>
</ul>
</li>
<li><code>show_filters</code>:<!-- -->
<ul>
<li><code>0</code>: render dashboard without Filter Bar</li>
<li><code>1</code> (default): render dashboard with Filter Bar if native filters are enabled</li>
</ul>
</li>
<li><code>expand_filters</code>:<!-- -->
<ul>
<li>(default): render dashboard with Filter Bar expanded if there are native filters</li>
<li><code>0</code>: render dashboard with Filter Bar collapsed</li>
<li><code>1</code>: render dashboard with Filter Bar expanded</li>
</ul>
</li>
</ul>
<p>For example, when running the local development build, the following will disable the
Top Nav and remove the Filter Bar:
<code>http://localhost:8088/superset/dashboard/my-dashboard/?standalone=1&amp;show_filters=0</code></p></div><footer class="theme-doc-footer docusaurus-mt-lg"><div class="row margin-top--sm theme-doc-footer-edit-meta-row"><div class="col"><a href="https://github.com/apache/superset/edit/master/docs/versioned_docs/version-6.0.0/using-superset/creating-your-first-dashboard.mdx" target="_blank" rel="noopener noreferrer" class="theme-edit-this-page"><svg fill="currentColor" height="20" width="20" viewBox="0 0 40 40" class="iconEdit_Z9Sw" aria-hidden="true"><g><path d="m34.5 11.7l-3 3.1-6.3-6.3 3.1-3q0.5-0.5 1.2-0.5t1.1 0.5l3.9 3.9q0.5 0.4 0.5 1.1t-0.5 1.2z m-29.5 17.1l18.4-18.5 6.3 6.3-18.4 18.4h-6.3v-6.2z"></path></g></svg>Edit this page</a></div><div class="col lastUpdated_JAkA"><span class="theme-last-updated">Last updated<!-- --> on <b><time datetime="2025-09-02T17:28:12.000Z" itemprop="dateModified">Sep 2, 2025</time></b> by <b>dependabot[bot]</b></span></div></div></footer></article><nav class="docusaurus-mt-lg pagination-nav" aria-label="Docs pages"><a class="pagination-nav__link pagination-nav__link--prev" href="/docs/6.0.0/configuration/theming"><div class="pagination-nav__sublabel">Previous</div><div class="pagination-nav__label">Theming</div></a><a class="pagination-nav__link pagination-nav__link--next" href="/docs/6.0.0/using-superset/exploring-data"><div class="pagination-nav__sublabel">Next</div><div class="pagination-nav__label">Exploring Data in Superset</div></a></nav></div></div><div class="col col--3"><div class="tableOfContents_bqdL thin-scrollbar theme-doc-toc-desktop"><ul class="table-of-contents table-of-contents__left-border"><li><a href="#creating-your-first-dashboard" class="table-of-contents__link toc-highlight">Creating Your First Dashboard</a><ul><li><a href="#connecting-to-a-new-database" class="table-of-contents__link toc-highlight">Connecting to a new database</a></li><li><a href="#registering-a-new-table" class="table-of-contents__link toc-highlight">Registering a new table</a></li><li><a href="#customizing-column-properties" class="table-of-contents__link toc-highlight">Customizing column properties</a></li><li><a href="#superset-semantic-layer" class="table-of-contents__link toc-highlight">Superset semantic layer</a></li><li><a href="#creating-charts-in-explore-view" class="table-of-contents__link toc-highlight">Creating charts in Explore view</a></li><li><a href="#creating-a-slice-and-dashboard" class="table-of-contents__link toc-highlight">Creating a slice and dashboard</a></li><li><a href="#manage-access-to-dashboards" class="table-of-contents__link toc-highlight">Manage access to Dashboards</a></li><li><a href="#publishing-a-dashboard" class="table-of-contents__link toc-highlight">Publishing a Dashboard</a></li><li><a href="#mark-a-dashboard-as-favorite" class="table-of-contents__link toc-highlight">Mark a Dashboard as Favorite</a></li><li><a href="#customizing-dashboard" class="table-of-contents__link toc-highlight">Customizing dashboard</a></li></ul></li></ul></div></div></div></div></main></div></div></div><footer class="theme-layout-footer footer"><div class="container container-fluid"><div class="footer__bottom text--center"><div class="footer__copyright">
<div class="footer__applitools">
We use &nbsp;<a href="https://applitools.com/" target="_blank" rel="nofollow"><img src="/img/applitools.png" title="Applitools"></a>
</div>
<p>Copyright © 2024,
The <a href="https://www.apache.org/" target="_blank" rel="noreferrer">Apache Software Foundation</a>,
Licensed under the Apache <a href="https://apache.org/licenses/LICENSE-2.0" target="_blank" rel="noreferrer">License</a>.</p>
<p><small>Apache Superset, Apache, Superset, the Superset logo, and the Apache feather logo are either registered trademarks or trademarks of The Apache Software Foundation. All other products or name brands are trademarks of their respective holders, including The Apache Software Foundation.
<a href="https://www.apache.org/" target="_blank">Apache Software Foundation</a> resources</small></p>
<img class="footer__divider" src="/img/community/line.png" alt="Divider">
<p>
<small>
<a href="/docs/security/" target="_blank" rel="noreferrer">Security</a>&nbsp;|&nbsp;
<a href="https://www.apache.org/foundation/sponsorship.html" target="_blank" rel="noreferrer">Donate</a>&nbsp;|&nbsp;
<a href="https://www.apache.org/foundation/thanks.html" target="_blank" rel="noreferrer">Thanks</a>&nbsp;|&nbsp;
<a href="https://apache.org/events/current-event" target="_blank" rel="noreferrer">Events</a>&nbsp;|&nbsp;
<a href="https://apache.org/licenses/" target="_blank" rel="noreferrer">License</a>&nbsp;|&nbsp;
<a href="https://privacy.apache.org/policies/privacy-policy-public.html" target="_blank" rel="noreferrer">Privacy</a>
</small>
</p>
<!-- telemetry/analytics pixel: -->
<img referrerpolicy="no-referrer-when-downgrade" src="https://static.scarf.sh/a.png?x-pxid=39ae6855-95fc-4566-86e5-360d542b0a68">
</div></div></div></footer></div>
</body>
</html>