Plotting Series from Multiple Sources in the Same Chart

07-12-2018 11:35 AM
New Contributor III

Currently, the chart widget can only use a single layer or table. It can support multiple series, but only if they are from the same layer or table. It would be useful to be able to render charts from multiple layers or tables in the same chart.

Tags (2)
1 Comment
Status changed to: Under Consideration

Where is the data stored? If in an relational database (and assuming complimentary table schemas), you might be able (as a workaround) to create a view that merges the tables using SQL commands like UNION or UNION ALL. That view could then be published to a service/layer that gets pulled into the dashboard for display.  For other data sources, the only way to do this would be to physically merge them before being brought into the dashboard.