I'm working with an organizational chart that includes multiple employees with the same name in different teams. For example:
I want to accurately count the total number of unique employees, regardless of their team assignments. In this case, the correct count should be 2 (John and Sarah).
Best answer by Emma D
Hi
=COUNT(UNIQUE(MAP(children.Name, x => ASSTRING(x))))
The underlying issue is with the way we handle linked data values in formulas. This workaround maps the linked data values with a conversion, thus allowing the UNIQUE function to work as expected.
Hopefully this helps, but please don’t hesitate to follow up if you have any further questions!
+7Hi
=COUNT(UNIQUE(CHILDREN."Name"))
Hope this helps!
Hi
Example: John reports to multiple supervisors and works in various Team. I want John to be represented as one headcount in my Lucidchart Analysis. Please refer to the google sheet screenshot and create another formula for the scenario below.
+7My apologies- it looks like the aforementioned formula only works when you reference a custom data property on your org chart shapes. I’ve reached out internally for possible alternatives and will come back to you shortly.
+7Hi
=COUNT(UNIQUE(MAP(children.Name, x => ASSTRING(x))))
The underlying issue is with the way we handle linked data values in formulas. This workaround maps the linked data values with a conversion, thus allowing the UNIQUE function to work as expected.
Hopefully this helps, but please don’t hesitate to follow up if you have any further questions!
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
