Forum Discussion

adriancho_BI's avatar
adriancho_BI
Regular Visitor
2 years ago

Create Category from numeric field

Hello! I'm trying to create a simple categry with the next logic, but I don't see the category "0%" and I don't know how to make ir appear. For devices with this field = 0.00 shows me the next catego...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

adriancho_BI Could be a decimal precision issue. Try this:

%_Range_Column =
SWITCH (
    TRUE(),
data_device[%_days_with_traffic] < 0.001, "0%",
data_device[%_days_with_traffic] <= 0.25, ">0 -25%",
data_device[%_days_with_traffic] <= 0.5, ">25 -50%",
data_device[%_days_with_traffic] <= 0.75, ">50 -75%",
data_device[%_days_with_traffic] > 0.75, ">75-100%",
"0%" )
  • adriancho_BI's avatar
    adriancho_BI
    Regular Visitor
    2 years ago

    Thanks for the answer! But I've already tried that approach without any change 😞