4Justme2 Posted August 29, 2012 Share Posted August 29, 2012 I figured it was time to reach out to the community as I'm beginning to tear my hair out over this. I need to be able to count the number of unique values in a portal based on the "participant" field. I've tried a number of solutions I found online but can't get any of them to do what I want. Example: from the portal rows items below I want to return a count of 3 (Judy, Bette and Jim). It seems like this would be so easy I MUST be making it way more complicated then it is. Judy Judy Bette Jim Judy I'm including a small zip file of my data. Any chance someone could take a look at it for me? Just sign in as a Guest and you should have no problem opening the file. Thank you... mp UniqueValues.zip Link to comment Share on other sites More sharing options...
doughemi Posted August 30, 2012 Share Posted August 30, 2012 Create a Value List named UniqueParticipants, of services.PEOPLE::cFullName_First_Last (Only related values starting from _EVENTS). Now UniqueParticipantCount = ValueCount ( ValueListItems ( Get ( FileName ) ; "UniqueParticipants" ) ) Link to comment Share on other sites More sharing options...
comment Posted August 30, 2012 Share Posted August 30, 2012 Example: from the portal rows items below I want to return a count of 3 (Judy, Bette and Jim). Try = Count ( Services.PEOPLE::ID_PEO_pk ) Link to comment Share on other sites More sharing options...
doughemi Posted August 30, 2012 Share Posted August 30, 2012 Way cool! I didn't know that Count() would work that way through a join table. But like all your other elegant solutions, so logical once it's pointed out. Thanks. Link to comment Share on other sites More sharing options...
4Justme2 Posted August 31, 2012 Author Share Posted August 31, 2012 CountUnique Copy.zipI changed the context from which I need to implement this solution. I tried the above suggestion but am still doing something wrong. For some reason my uniqueParticipantCount = 0 on all the records and the cCountUnique is really funky: On Bette's record the cCountUnique is showing as 7 and it should be 2 uniques (Connie & Deb) Bill's result is correct... 3 uniques (Nancy, Mary & Michael) On Bruce's record the cCountUnique is showing as 2 and it should be 3 uniques (Deb, Lucy and Connie) Any ideas where I've gone wrong? Link to comment Share on other sites More sharing options...
comment Posted August 31, 2012 Share Posted August 31, 2012 See if this makes it clearer: CountUnique3.fp7.zip Link to comment Share on other sites More sharing options...
4Justme2 Posted August 31, 2012 Author Share Posted August 31, 2012 Is there I way that I can do this so I can still have the date that corresponds with the person included the portal? I take it back (I was thinking about a different post I had sent). This unique count is exactly what I was looking for. Thank you so much for your help with this. I do appreciate!!! :laugh2: Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4256 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now