Home › Forums › Chart Support › Date AxisX (Trend) + Group and Stack › Reply To: Date AxisX (Trend) + Group and Stack
Thanks for the quick response. As an example of what I am looking for, please see: https://canvasjs.com/forums/topic/date-axisx-trend-group-and-stack/
Imagine with the following data return, I am defining my dataSeries and dataPoints arrays: [ { “trend”: “2021-01-01”, “year”: 2021, “group”: “Partner 1”, “stack”: “Expense”, “value”: “2000” }, { “trend”: “2021-01-01”, “year”: 2021, “group”: “Partner 1”, “stack”: “Contribution”, “value”: “5000” }, { “trend”: “2021-01-01”, “year”: 2021, “group”: “Partner 1”, “stack”: “Income”, “value”: “1000” }, { “trend”: “2021-01-01”, “year”: 2021, “group”: “Partner 2”, “stack”: “Expense”, “value”: “3000” }, { “trend”: “2021-01-01”, “year”: 2021, “group”: “Partner 2”, “stack”: “Contribution”, “value”: “2000” }, { “trend”: “2021-01-01”, “year”: 2021, “group”: “Partner 2”, “stack”: “Income”, “value”: “3000” }, { “trend”: “2022-01-01”, “year”: 2022, “group”: “Partner 1”, “stack”: “Expense”, “value”: “1500” }, { “trend”: “2022-01-01”, “year”: 2022, “group”: “Partner 1”, “stack”: “Contribution”, “value”: “3000” }, { “trend”: “2022-01-01”, “year”: 2022, “group”: “Partner 1”, “stack”: “Income”, “value”: “2000” }, { “trend”: “2022-01-01”, “year”: 2022, “group”: “Partner 2”, “stack”: “Expense”, “value”: “1000” }, { “trend”: “2022-01-01”, “year”: 2022, “group”: “Partner 2”, “stack”: “Contribution”, “value”: “1000” }, { “trend”: “2022-01-01”, “year”: 2022, “group”: “Partner 2”, “stack”: “Income”, “value”: “4000” }, { “trend”: “2023-01-01”, “year”: 2023, “group”: “Partner 1”, “stack”: “Expense”, “value”: “2500” }, { “trend”: “2023-01-01”, “year”: 2023, “group”: “Partner 1”, “stack”: “Contribution”, “value”: “1000” }, { “trend”: “2023-01-01”, “year”: 2023, “group”: “Partner 1”, “stack”: “Income”, “value”: “3000” }, { “trend”: “2023-01-01”, “year”: 2023, “group”: “Partner 2”, “stack”: “Expense”, “value”: “2000” }, { “trend”: “2023-01-01”, “year”: 2023, “group”: “Partner 2”, “stack”: “Contribution”, “value”: “1000” }, { “trend”: “2023-01-01”, “year”: 2023, “group”: “Partner 2”, “stack”: “Income”, “value”: “3500” } ]
For this particular use case my goal would be to produce a column chart with annual trends on the x axis, with each year having a side-by-side column for each group property value, where each column is then stacked independently based on each stack property value.