two x-axis with year values

[TomBond77]

Hi experts

I have the following dataset:

The first two columns can be integrated well into a bar chart, the last 2 columns also in another bar chart.

Is there a solution to combine both year types into one chart, with two x-axis? Both year types are derived from different date types.

Thank you, Tom

[ogster1974 · Accepted solution]

Yes. Remodel your data.

Load the first 2 columns and add new status field = Open, rename Value Open to Value and Year Open to Year

then concentrate and load the next 2 columns and add new status = Closed, rename Value Closed to Value and Year Closed to Year

.

Should look like this.

Then you can produce this.

[TomBond77]

Thank you! This works!

 A last question, the sorting of month-year is not working, any ideas? Thank you.

[MayilVahanan]

Hi

If Year/Month column is date format, then sort by Numerically, will work.

However, if its text format, then need to convert text format to date format by using date#(date()).

If you create filter object with Year/Month column, if its date format, it will display the value in right side.

[TomBond77]

Thank you!

[TomBond77]

Sorry, I lost your solution 😞 It worked.

But I have done some changes and lost the solution.