My data consists of distances driven in different areas (urban, highway, …) and also planned values for each of these categories. My goal is to visualize them in a bar chart, with the categories on the x axis, the distances on the y axis, and two bars for each category, the actual and the planned value. Similar to this:
Even better if the bars are stacked, e.g. the planned value as an unfilled bar with dashed outline for example.
However, the actual distances are aggregated from an InfluxDB, while the planned data is stored in a MySQL DB, so they have to be queried separately.
Here are the queries, visualized as bars next to each other: