question

ChristianWunderlich-6097 avatar image
0 Votes"
ChristianWunderlich-6097 asked asergaz answered

categorization colors not applying correctly

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!

127795-rawdata.png

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

127748-zones.png

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!
127760-tsicolors.png

Does anyone has an answer to this?

azure-time-series-insights
rawdata.png (37.6 KiB)
zones.png (14.4 KiB)
tsicolors.png (56.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ChristianWunderlich-6097 ,
I am trying to reproduce this on my side. If you have followed a specific tutorial please share.

Thanks!

0 Votes 0 ·

1 Answer

asergaz avatar image
0 Votes"
asergaz answered

Hello @ChristianWunderlich-6097 ,

I have noticed that your iff statement should include <=20 to show you the expected results.

 iff(tolong($event.temperature.Double) <= 30, iff(tolong($event.temperature.Double) <= 20, 'cold', 'normal'), iff(tolong($event.temperature.Double) > 30, 'hot', 'normal'))

Neverheless, because you are ingesting hourly temperature values, if TSI ingests temperature 20.5 hourX and then 19.5 hourY you will have the area painted in color "Yellow" between hourX and hourY - and that is expected since TSI assumes you had a flat value of 20.5 during that period.

Thank you!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.