hconcat Bar Charts

[NaHolla]

I´m trying to adopt a Population Pyramid code from https://vega.github.io/vega-lite/examples/concat_population_pyramid.html

In this code the limits of the x axis for male / female are evaluated separatly. Thus max. values for the x axis in both plots differ, which sometimes give an wrong impression of the distribution.

I´m trying to set both axis to the same max value ig the max value of the dataset

I´ve tried to use joinaggregate and use the evaluated parameter to scale :

"$schema": "https://vega.github.io/schema/vega-lite/v5.json",
"description": "A population pyramid for the US in 2000.",
"data": { "url": "data/population.json"},
"transform": [
  {"filter": "datum.year == 2000"},
  {"calculate": "datum.sex == 2 ? 'Female' : 'Male'", "as": "gender"},
 { "joinaggregate": 
       [{
          "op": "sum",
          "field": "people",
          "as": "MaxVal"
       }]
      }
],

and used it in

"encoding": {
  "y": {
    "field": "age", "title": null,
    "axis": null, "sort": "descending"
  },
  "x": {
    "aggregate": "sum", "field": "people",
    "title": "population",
    "axis": {"format": "s"},
    "scale": {"domain": [0, "MaxVal"]},

  },

but it did´n work.

Any Ideas how to solve that?

Thanks!

original Code:

    {
      "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
      "description": "A population pyramid for the US in 2000.",
      "data": { "url": "data/population.json"},
      "transform": [
        {"filter": "datum.year == 2000"},
        {"calculate": "datum.sex == 2 ? 'Female' : 'Male'", "as": "gender"}
      ],
      "spacing": 0,
      "hconcat": [{
        "transform": [{
          "filter": {"field": "gender", "equal": "Female"}
        }],
        "title": "Female",
        "mark": "bar",
        "encoding": {
          "y": {
            "field": "age", "axis": null, "sort": "descending"
          },
          "x": {
            "aggregate": "sum", "field": "people",
            "title": "population",
            "axis": {"format": "s"},
            "sort": "descending"
          },
          "color": {
            "field": "gender",
            "scale": {"range": ["#675193", "#ca8861"]},
            "legend": null
          }
        }
      }, {
        "width": 20,
        "view": {"stroke": null},
        "mark": {
          "type": "text",
          "align": "center"
        },
        "encoding": {
          "y": {"field": "age", "type": "ordinal", "axis": null, "sort": "descending"},
          "text": {"field": "age", "type": "quantitative"}
        }
      }, {
        "transform": [{
          "filter": {"field": "gender", "equal": "Male"}
        }],
        "title": "Male",
        "mark": "bar",
        "encoding": {
          "y": {
            "field": "age", "title": null,
            "axis": null, "sort": "descending"
          },
          "x": {
            "aggregate": "sum", "field": "people",
            "title": "population",
            "axis": {"format": "s"}
          },
          "color": {
            "field": "gender",
            "legend": null
          }
        }
      }],
      "config": {
        "view": {"stroke": null},
        "axis": {"grid": false}
      }
    }