Hi,
I use Group by option on field Project (linked field). But I don't understand why 2 groups for the same project are displayed.
An idea ?
Solved
group by option issue
+3Best answer by TheTimeSavingCo
Right, I have 2 records in the table Project. But in this table, the group by on the same field is valid.
Yeap that's true. In "Projet" when you use the Group By functionality you're grouping by the text value of "C", which gives you the result you expect
However when you're grouping by the linked field, while it's displaying as "C", it's actually grouping by the record ID of the linked record. Here's some screenshots that help with demonstrating this:
Does that make sense?
+31Hm that would happen if you actually had two records in the table "Project" with a primary field value of "C". Could you check whether that's what's happening?
+3Right, I have 2 records in the table Project. But in this table, the group by on the same field is valid.
+31Right, I have 2 records in the table Project. But in this table, the group by on the same field is valid.
Yeap that's true. In "Projet" when you use the Group By functionality you're grouping by the text value of "C", which gives you the result you expect
However when you're grouping by the linked field, while it's displaying as "C", it's actually grouping by the record ID of the linked record. Here's some screenshots that help with demonstrating this:
Does that make sense?
+3Ok, to avoid this
I apply Group By option on a calculated field based on project field which allows to obtain the expected view
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.