Iโm sure I saw a question like this but I canโt find it. Iโm presenting data in a Deck View and grouping it, in one tab, by a Yes/No field. It ONLY shows Y or N which doesnโt give the user much context. Iโd rather it say, โIs Urgentโ for Y and โNot Urgentโ for N. Any way to do this?
Solved! Go to Solution.
You can also simplify this to: IF([URGENT], โIs URGENTโ,โNot Urgentโ)
Virtual Colunm and Concatenate. I can explain more if needed
Thanks. I had seen that from an old post so I guess that is the way to go.
Instead of Concatenate, I used IF([URGENT]=TRUE, โIs URGENTโ,โNot Urgentโ) in my virtual column.
Then I added it to the slice my view was based upon and selected that column for my Group By.
It worked. @retailpartnercom Do you see any reason why Concatenate would be better than IF?
Oh, my bad. Your right, concatenate wouldnโt work. I was thinking that you would put โY, Is URGENTโ or โN, Is not Urgentโ, but your way is better.
You could create a separate table:
Key | Label |
---|---|
TRUE |
Is URGENT |
FALSE |
Not Urgent |
Then make the By Urgency column a Ref to that table.
You can also simplify this to: IF([URGENT], โIs URGENTโ,โNot Urgentโ)
How does that work? Doesnโt the first part have to be a condition?
The first part must evaluate to TRUE or FALSE. Yes/No columns are True/False. So [URGENT] already has one of those values. There is no need to compare it to a hardcoded boolean.
Oh thatโs smart!
What @Bahbus said. The first part is an expressionโany expressionโthat evaluates to a Yes/No value. [URGENT]
is an expression that evaluates to the value of the URGENT column, which is itself a Yes/No value.
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |