XY Chart suggestions to group columns

Hello, can you help me with a suggestion about how can i group by shift ("Turno") and separate the groups by Date in a XY chart component?, i make a named query and to get the data, but i need to plot in a chart in the most understandable way possible. today i achieved this:

[
  {
    "id": 1,
    "Availability": 79.96180725097656,
    "Performance": 78.5,
    "Quality": 83.43949127197266,
    "OEE": 52.37498474121094,
    "Turno": 1,
    "Date": 1686601740000
  },
  {
    "id": 2,
    "Availability": 90.70138549804688,
    "Performance": 40.400001525878906,
    "Quality": 95.04950714111328,
    "OEE": 34.8293342590332,
    "Turno": 2,
    "Date": 1686626971000
  },
  {
    "id": 3,
    "Availability": 100,
    "Performance": 32.5,
    "Quality": 103.07691955566406,
    "OEE": 33.5,
    "Turno": 3,
    "Date": 1686657540000
  },
  {
    "id": 4,
    "Availability": 82.88541412353516,
    "Performance": 84,
    "Quality": 92.26190185546875,
    "OEE": 64.23619079589844,
    "Turno": 1,
    "Date": 1686688140000
  },
  {
    "id": 5,
    "Availability": 81.98958587646484,
    "Performance": 43.83333206176758,
    "Quality": 93.91635131835938,
    "OEE": 33.75238037109375,
    "Turno": 2,
    "Date": 1686713340000
  },
  {
    "id": 6,
    "Availability": 85.27083587646484,
    "Performance": 60.33333206176758,
    "Quality": 93.64640808105469,
    "OEE": 48.17802047729492,
    "Turno": 3,
    "Date": 1686743940000
  }
]

it looks now :

i like to group by day on the X axis and also by shift "Turno" , is there a way to make on the chart or the better option is modify the DB to get all data for day?

what you think?

Hello,

Perhaps the simplest approach is to add this grouping in your queries feeding this table. Instead of trying to manipulate the data after the fact in the chart binding.

Frank