Forum Discussion

Ashes's avatar
Ashes
Frequent Visitor
2 years ago
Solved

Icon Conditional Formatting and Calculation Groups using Field Values

I've just come across the icon conditional formatting and calculation groups. When I was trying to combine them to reduce the time needed in doing the conditional formatting on each columns I thought...
Need Help
Tips and Tricks
  • Ashes's avatar
    Ashes
    2 years ago

    Ok I think I have discovered the root cause.

    Because the underlying measure is originally of a type that is Integer, it is not adjusting to the type String that the Calculation Group is adjusting it to. And a field value source requires a measure to have a type of String.

    So if I convert the measure to output a string initially and then do the switch on that through the Calculation Group it is now selectable.

    So the problem is that the measure maintains it's original Data Type even if the Calculation Group is changing the output.

Ashes's avatar
Ashes
Frequent Visitor
2 years ago

Thanks for the vids. Unfortunately they didn't seem to address the issue I am experiencing, where I am unable to select a measure tweaked by the Calculated Group for a Field Value option for Icon Conditional Formatting, but is selectable as a Rule input to the Icon Conditional Formatting (just can't be used there because it doesn't contain values).

Effort to provide them appreciated though.