If I understand you well, ‘simply’ you want to have the same color for every day, you could use the graph you show and in series override put a color for all the series:
You can also achieve something similar with plotly,
your query may or may not return a column of time,
with plotly, you can do the query as timeserie,
or as a table, in the first case you will need the time column, in the second you do not need it, in any case, plotly allows you to plot a column on the X axis and a different column on the Y axis.
I hope to be helpful, if I still can not understand you, please give me more details