Point chart - two (or more) data rows

I would like to add the average Y-axis values for each X-axis value to a point chart. Is there any way to do this please? I would like to achieve a similar result to the second picture.

Expected result is here.

Data example

Here you go.

Data:

Add Deneb visual and then add the following fields ensuring that don't summarise is selected for each column.

Inside Deneb, paste the following spec.

{
  "data": {"name": "dataset"},
  "transform": [
    {
      "calculate": "datum['weekday ']<= 5?'weekday':'weekend'",
      "as": "type"
    }
  ],
  "layer": [
    {"mark": {"type": "point"}},
    {
      "mark": {"type": "line", "interpolate":"basis"},
      "encoding": {
        "x": {
         
          "field": "hour"
        },
        "y": {
          "aggregate": "mean",
          "field": "cumulative_daily_steps"
        }
      }
    }
  ],
  "encoding": {
    "x": {
      "field": "hour",
      "type": "quantitative",
      "axis": {"title": "Hour of Day"}
    },
    "y": {
      "field": "cumulative_daily_steps",
      "type": "quantitative",
      "axis": {
        "title": "Cumulative Step Count"
      }
    },
    "color": {
      "field": "type",
      "type": "nominal",
      "scale": {
        "range": ["red", "green"]
      },
      "legend": {"title": ""}
    }
  }
}