Line Chart with Time on Y-Axis and Date on X-Axis

Hi all,

Has anyone created a line chart having the Time on Y-Axis and Date on X-Axis? We're looking to visualise data for  the time of day that requests enter the queue for an application to identify peak periods.

Below is a sample interface we're playing with, essentially we want to change the "# cases" on the Y-axis to "time of day". Any information or examples will be much appreciated! Thank you.

a!localVariables(
  local!requests: a!dataSubset(
    data: {
      {
        created_on: datetime(
          2019,
          1,
          10,
          5,
          7,
          10,
          0
        ),
        id_count: 65,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          11,
          5,
          7,
          10,
          0
        ),
        id_count: 66,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          12,
          5,
          7,
          10,
          0
        ),
        id_count: 67,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          13,
          5,
          7,
          10,
          0
        ),
        id_count: 70,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          14,
          6,
          7,
          10,
          0
        ),
        id_count: 72,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          15,
          6,
          7,
          10,
          0
        ),
        id_count: 69,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          16,
          6,
          7,
          10,
          0
        ),
        id_count: 75,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          17,
          6,
          7,
          10,
          0
        ),
        id_count: 73,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          18,
          6,
          7,
          10,
          0
        ),
        id_count: 77,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          19,
          6,
          7,
          10,
          0
        ),
        id_count: 80,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          20,
          6,
          7,
          10,
          0
        ),
        id_count: 76,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          21,
          6,
          7,
          10,
          0
        ),
        id_count: 78,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          22,
          6,
          7,
          10,
          0
        ),
        id_count: 80,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          23,
          6,
          7,
          10,
          0
        ),
        id_count: 77,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          24,
          6,
          7,
          10,
          0
        ),
        id_count: 75,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          25,
          6,
          7,
          10,
          0
        ),
        id_count: 80,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          26,
          6,
          7,
          10,
          0
        ),
        id_count: 83,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          27,
          6,
          7,
          10,
          0
        ),
        id_count: 86,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          28,
          6,
          7,
          10,
          0
        ),
        id_count: 83,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          29,
          6,
          7,
          10,
          0
        ),
        id_count: 88,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          30,
          6,
          7,
          10,
          0
        ),
        id_count: 90,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          1,
          31,
          6,
          7,
          10,
          0
        ),
        id_count: 94,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          1,
          1,
          7,
          10,
          0
        ),
        id_count: 135,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          2,
          1,
          7,
          10,
          0
        ),
        id_count: 132,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          3,
          1,
          7,
          10,
          0
        ),
        id_count: 136,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          4,
          1,
          7,
          10,
          0
        ),
        id_count: 138,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          5,
          1,
          7,
          10,
          0
        ),
        id_count: 134,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          6,
          1,
          7,
          10,
          0
        ),
        id_count: 137,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          7,
          1,
          7,
          10,
          0
        ),
        id_count: 135,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          8,
          1,
          7,
          10,
          0
        ),
        id_count: 137,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          9,
          1,
          7,
          10,
          0
        ),
        id_count: 135,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          10,
          0,
          0,
          0,
          0
        ),
        id_count: 138,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          11,
          0,
          0,
          0,
          0
        ),
        id_count: 137,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          12,
          0,
          0,
          0,
          0
        ),
        id_count: 139,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          13,
          0,
          0,
          0,
          0
        ),
        id_count: 140,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          14,
          0,
          0,
          0,
          0
        ),
        id_count: 136,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          15,
          0,
          0,
          0,
          0
        ),
        id_count: 142,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          16,
          0,
          0,
          0,
          0
        ),
        id_count: 146,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          17,
          0,
          0,
          0,
          0
        ),
        id_count: 144,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          18,
          0,
          0,
          0,
          0
        ),
        id_count: 146,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          19,
          0,
          0,
          0,
          0
        ),
        id_count: 150,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          20,
          0,
          0,
          0,
          0
        ),
        id_count: 146,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          21,
          0,
          0,
          0,
          0
        ),
        id_count: 146,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          22,
          0,
          0,
          0,
          0
        ),
        id_count: 148,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          23,
          0,
          0,
          0,
          0
        ),
        id_count: 145,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          24,
          0,
          0,
          0,
          0
        ),
        id_count: 147,
        time: time(
          5,
          7,
          10,
          0
        )
      },
      {
        created_on: datetime(
          2019,
          3,
          25,
          0,
          0,
          0,
          0
        ),
        id_count: 145,
        time: time(
          5,
          7,
          10,
          0
        )
      }
    }
  ),
  {
    a!lineChartField(
      label: "Requests",
      categories: index(
        local!requests.data,
        "created_on"
      ),
      series: {
        a!chartSeries(
          label: "Requests",
          data: index(
            local!requests.data,
            "id_count"
          ),
          color: "GREEN"
        )
      },
      yAxisTitle: "# cases"
    )
  }
)

  Discussion posts and replies are publicly visible