Forum Replies Created by Jason Ludwig

Viewing 2 posts - 1 through 2 (of 2 total)
  • in reply to: Date AxisX (Trend) + Group and Stack #43676

    I see. I was thinking it would be something like this. Thank you for the full working example.

    in reply to: Date AxisX (Trend) + Group and Stack #43655

    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.

Viewing 2 posts - 1 through 2 (of 2 total)