With the reference to the previous post (Shading rooms using CSV file values), I am trying to color the rooms based on the values taken from the excel file. I have taken rooms data from the Revit model and imported data from the excel file. But I don’t know how to set the threshold to color the rooms. For example; Room value > 20 have the color “Red”. I am attaching the file below.
@mellouze As it says over my “color-nodes” they are from Clockwork… the OOTB way of making them is shown by @erfajo
@mohammadarslan You have not written either the “if-statement” (first codeblock) or the “transpose” block correctly…
Unless of course you only want two colors in which case there is no reason to use three colors… I’m just trying to show you an option not give you the entire solution. That way you might even learn a little from this adventure
The logic behind the if-statement is:
if x < 40 then return “Red”
if x < 60 then return “Blue”
else return “Green”
And I’m only using the first two sub-lists (lst[0],lst[1]) in the transpose as the third list (lst2) is exchanged for actual colors rather than “values”…
Generally you can identify “function” by the color of the “header” of the nodes…
hello,
I am quiet a beginner in Dynamo, but I am try to do something very similar to what you did here, change colors of rooms based on excel data that I have.I would really appreciate any leads or hints where to start and how to do it
