Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you! This works!
A last question, the sorting of month-year is not working, any ideas? Thank you.
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.
Thank you!
Sorry, I lost your solution 😞 It worked.
But I have done some changes and lost the solution.