That is very close to my expectation. However had below issues.
1. I see you have hard coded the sort of new_date which will remains all the time. I think sort by field=Date and aggregation set to Min/Max will solve(dynamically change the month) the issue. It is working fine but let me know if it breaks out with other aggregations.
2. Can i have dual axis from the below chart. i.e.wanted to display line on top of each bar.
I am very close to it with calc, but not aligning on top of each bar consistently.
Current Vs Previous Trend.twbx 89.5 KB