Is there any way to highlight Boolean formatted or Text formatted metric using Conditional Formatting ?
Solved
Highlight Text or Boolean metric using Conditional Formatting.
- Trendsetter
Best answer by Elliot
Hi Susmita
Good question! As
This means you can’t do conditional formatting on text formatted metrics, but you CAN do it on Boolean formatted metrics using empty/non empty.
Regarding text formatted properties, you are unable to use conditional formatting, however, you might be able to leverage Emojis in dimension items to achieve the same result.
For example, see below.
The indicator column is a metric within a table. You can then use a formula to show different emojis depending on what condition you want to set. I’ve only done this a couple of times, but, it’s a powerful work around.
If you let me know the context of what youre trying to achieve I can advise on what options we have available.
Hi Susmita, at the moment conditional formatting is only available for numbers, or, empty/not empty cells. However, this is in our roadmap so please stay tuned while our team works on it :)
+9- Employee
- Answer
Hi Susmita
Good question! As
This means you can’t do conditional formatting on text formatted metrics, but you CAN do it on Boolean formatted metrics using empty/non empty.
Regarding text formatted properties, you are unable to use conditional formatting, however, you might be able to leverage Emojis in dimension items to achieve the same result.
For example, see below.
The indicator column is a metric within a table. You can then use a formula to show different emojis depending on what condition you want to set. I’ve only done this a couple of times, but, it’s a powerful work around.
If you let me know the context of what youre trying to achieve I can advise on what options we have available.
- Trendsetter
Hi
Thank You, appreciate your help so much..!!
I am trying to highlight Version Status Column, if my status is open is should show red and if it is locked then green.
It would be great help if you could help me with how to use Emojis in dimension items.
+13- Employee
Hi
Here’s a short walk through of turning a boolean metric in a status using a dimension and emojis.
The steps are the following:
- Create a dimension (e.g. Boolean Status) with two / three items (True, False, and eventually blank)
- Create a new metric with format Dimension > Boolean Status
- Input a formula that replaces the boolean with the corresponding items
IF('Boolean by City', 'Boolean Status'."✅", IF(NOT 'Boolean by City', 'Boolean Status'."❌", 'Boolean Status'."🤷")) - You’re good to go! You may then rename the items as you wish, the formula should update automatically.
Please let me know if this helps!
François (Pigment)
+8- Wallflower
Hi
Letting you know that conditional formatting is supported for Numbers, Text, Booleans, Dimensions and Dates, and there are many built-in conditions that can be applied to create rules.
For more information, see:
Thanks,
Sharon
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.