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?