Reply To: Date AxisX (Trend) + Group and Stack

[Jason Ludwig]

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.