Hi everyone,
quick question about categorization with colors in TSI. I have the following raw data send to event hubs. As you can see, i have extended this raw data with a color column containing some iff statements to create zones (cold, normal, hot) based on the actual temperature! As you see, this works!

Now, if I take the same query and apply it to TSI, it behaves differently than expected!

take a look especially to the markers set. Marker 3 and 4 should be yellow instead of green because temp is below 20. The same applies for Marker 5. This should be green and not yellow. I dont know how i can change this behavior!
Does anyone has an answer to this?