GitHub user dosubot[bot] added a comment to the discussion: Questions about mixed chart.
<!-- Answer --> Yes, there are a few alternatives: **1. Virtual Dataset (Recommended)** [Create a virtual dataset in SQL Lab using UNION or JOIN queries](https://github.com/apache/superset/discussions/32495#discussioncomment-12385933) to combine your multiple tables into one. Then use that single dataset with any chart type. For example: ```sql SELECT date, metric1, 'source_a' as source FROM table_a UNION ALL SELECT date, metric1, 'source_b' as source FROM table_b UNION ALL SELECT date, metric1, 'source_c' as source FROM table_c ``` **2. Multiple Charts on a Dashboard** [Place separate charts on a dashboard (one per dataset) and use native filters that apply across all charts](https://github.com/apache/superset/discussions/36846). This keeps things visually coordinated even though the data comes from different sources. **3. Database View** [Create a view directly in your database that joins/unions the tables](https://github.com/apache/superset/discussions/31806#discussioncomment-11811672), then use that view as your Superset dataset. The virtual dataset approach is typically the most flexible since you can adjust the query as needed without requiring database admin access. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/fd3f07d4-7717-47e8-89f6-834a27c2577f?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/fd3f07d4-7717-47e8-89f6-834a27c2577f?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/fd3f07d4-7717-47e8-89f6-834a27c2577f?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/fd3f07d4-7717-47e8-89f6-834a27c2577f?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/fd3f07d4-7717-47e8-89f6-834a27c2577f?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/fd3f07d4-7717-47e8-89f6-834a27c2577f?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/fd3f07d4-7717-47e8-89f6-834a27c2577f?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=Yes%2C%20there%20are%20a%20few%20alternatives%3A%0A%0A%2A%2A1.%20Virtual%20Dataset%20%28Recommended%29%2A%2A%0A%5BCreate%20a%20virtual%20dataset%20in%20SQL%20Lab%20using%20UNION%20or%20JOIN%20queries%5D%28https%3A//github.com/apache/superset/discussions/32495%23discussioncomment-12385933%29%20to%20combine%20your%20multiple%20tables%20into%20one.%20Then%20use%20that%20single%20dataset%20with%20any%20chart%20type.%20For%20example%3A%0A%60%60%60sql%0ASELECT%20date%2C%20metric1%2C%20%27source_a%27%20as%20source%20FROM%20table_a%0AUNION%20ALL%0ASELECT%20date%2C%20metric1%2C%20%27source_b%27%20as%20source%20FROM%20table_b%0AUNION%20ALL%0ASELECT%20date%2C%20metric1%2C%20%27source_c%27%20as%20source%20FROM%20table_c%0A%60%60%60%0A%0A%2A%2A2.%20Multiple%20Char ts%20on%20a%20Dashboard%2A%2A%0A%5BPlace%20separate%20charts%20on%20a%20dashboard%20%28one%20per%20dataset%29%20and%20use%20native%20filters%20that%20apply%20across%20all%20charts%5D%28https%3A//github.com/apache/superset/discussions/36846%29.%20This%20keeps%20things%20visually%20coordinated%20even%20though%20the%20data%20comes%20from%20different%20sources.%0A%0A%2A%2A3.%20Database%20View%2A%2A%0A%5BCreate%20a%20view%20directly%20in%20your%20database%20that%20joins/unions%20the%20tables%5D%28https%3A//github.com/apache/superset/discussions/31806%23discussioncomment-11811672%29%2C%20then%20use%20that%20view%20as%20your%20Superset%20dataset.%0A%0AThe%20virtual%20dataset%20approach%20is%20typically%20the%20most%20flexible%20since%20you%20can%20adjust%20the%20query%20as%20needed%20without%20requiring%20database%20admin%20access.) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/38220) GitHub link: https://github.com/apache/superset/discussions/38220#discussioncomment-15912767 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
