Hi,
I would like to plot 365 lines with 23 hourly energy values (columns). There is also a column with the day of the name of the week, as I would like to stress the different behaviour along the week, and one with month name. I unpivoted the table and plotted putting “hours” in x axis and “Energy” in the y axis. Is there a way to color lines according to the color of the nominal value day of the week?
Thank you in advance for your support
Cecilia
Hello @CECDG_1,
I am not sure if I am understanding, but do you want to keep the same color you have assigned depending on the day (ie. Monday, Tuesday,…) ?
If you want to make sure a column uses the same coloring as another, say after you use the color manager, you can attach the blue square (the color model port) to a color appender to make sure you save that previous config of color assignment on a particular column, namely your days of week. It can look something like this:
In the color appender if we use the model, we can retain the same color scheme for that column with the days.
Let me know if this is what you were looking for,
TL
Hello @thor_landstrom,
sorry for the terrible delay, thank you for your kind answer. Maybe my question was not clear: I have to plot 365 lines (day) with hours as x-axis and Energy as y-axis, every day is a bell-shaped hourly energy function. I would like to have every line associated to a specific color, according to the colour assigned with Color Manager to nominal values of the day in another column (i.e. Sat and Sun = red lines, the other days in grey). The final plot should work as Scatter plot java script node with colorful dots according to nominal column records.
Thank you in advance
Kind regards
I doubt that a 365 line plot is somehow readable. Have you tried to use a Box Plot instead? One box for each Hour
Thank you, I agree with you, especially using 7 boxplots for the days of week but I need to give a friendly output to let unexpert people understand the pattern, the behaviour of hourly energy consumption through the week (expecially during the weekend) and through the year. Moreover I have to emphasize the abnormal daily behavior that implies particular conditions.
Hi,
I meant to create a boxplot w 24 boxes (one for each Hour).
Alternatively I recommend to use a Python matplotlib lineplot w transparency enabled. The more lines are on the same position the darker the area gets.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
