Adding datasets to Data Visualizations

[keithtan]

Before Xanadu, this sample chart below can be created by adding another dataset to show two columns per year.

However, in Xanadu, this option is no longer available due to the move to data visualisations.

Anyone knows how to recreate this in Xanadu?

[AndersBGS]

Hi @keithtan ,

You just need to add a data source into your visualization:

[devpatel]

In Xanadu, since the traditional two-column-per-year charting option is no longer available due to the shift to data visualizations, you can try the following workaround to achieve the same effect:

Option 1: Use Grouped Bar Charts

1. In Xanadu, navigate to the Data Visualizations section.
2. Select a Bar Chart and choose the Grouped Bar Chart option.
3. Add both datasets as separate series and set the category axis to "Year."
4. Ensure that both datasets are assigned different colors to distinguish them visually.

Option 2: Use Dual-Axis Charts

1. If the values differ significantly, you can use a dual-axis chart (one dataset on the left Y-axis and the other on the right).
2. Choose a Combo Chart and assign one dataset to bars and the other to lines for clarity.
3. Adjust the scaling to ensure readability.

Option 3: Pivot & Custom Formatting

1. Transform the data into a pivot-friendly format where each year has two subcategories (e.g., 2023 - Dataset A, 2023 - Dataset B).
2. Use Stacked or Clustered Column Charts to display both datasets side by side per year.

Would love to know more about your specific use case to suggest the best approach!