I have some data in an inline view that is grouped by a Y/N column (eg. Marked complete, true or false).
When grouping by this column, the group header appears as a Y or a N. Is there a way of changing this to a custom text? Eg. "Marked Complete" and "Not Marked Complete".
Solved! Go to Solution.
Do the below screenshots help?
Y/N Column Name : [Regular]
Yes /No display values expressions:
No display value expression:
Yes display value expression:
Group BY :Summary Gard View:
Group BY Setting in the view:
Are you using custom display values for the Yes/No column?
Yes, I've set Y = "Marked Complete" and N= "Not Marked Complete". Still coming up as N/Y for grouping header.
Could you try with
IF( AND(CONTEXT("View")="The View Name", NOT([Y/N Column Name])), "Not Marked Complete", " No") for N custom display value
and
IF( AND(CONTEXT("View")="The View Name", [Y/N Column Name]), "Marked Complete", "Yes") for Y custom display value?
Please note that for the inline views, the view name is the parent detail view in general as shown below, you would get the view name in the footer of app editor in mobile view.
I'm not sure I get you.
The data has a Y/N column (eg. has task been completed).
I want the data grouped by tasks completed = Y, and tasks completed = N.
When selecting the "grouped by" function within UX and using the YN column, they correctly group however the grouping header is Y and N. I have set the "Yes/No display values" within the column settings to reflect what I want by the grouping header is still Y/N.
Do the below screenshots help?
Y/N Column Name : [Regular]
Yes /No display values expressions:
No display value expression:
Yes display value expression:
Group BY :Summary Gard View:
Group BY Setting in the view:
Fantastic - works perfectly!
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |