I have a module where users indicate the "priority" of list members using a list formatted line item. These users can potentially assign different priorities to the same line items; a screenshot is attached that illustrates how two users have indicated different levels of priority (one High, one Medium).
Is there an easy way to catch these mismatches?
For additional context, I want to import this priority level into a separate, non-user-dimensioned module. If I can take it a step further and indicate which value should be used in the event of a mismatch that would be great. Otherwise, if all we can do is filter out cases of mismatches and manually go in to address them, that would be fine too.
This is great, thank you. Would you mind taking a step back and explaining the easiest way to create a fake users list based on the real users list? How do I go about tieing the real users to the fake users list?
I have created the Custom Users List and module as you advised. As such, my Users list and Custom Users List are identical. The only difference is that the Custom Users List has a top-level item "All Users".
I am still having trouble pulling those inputs from the real user module into this custom users module, and a lookup doesn't seem to be cutting it. At this point it is too late to switch the dimension over from Users to Custom Users in that module where these users were inputting data. Attached are some screenshots to help illuminate this:
1) Original Users dimensioned module. The line items at the bottom are the ones we want to be able to aggregate.
2) Error message, Custom Users dimensioned module, and a look at the formula. You can see that I am trying to use "Customer User Identifier", which should be identical for the Users and Custom Users, as a way to bridge the gap.
Due to not having the top level as well as security (the reason the lookup will not work), I don't believe your current configuration is going to work. Have you thought of breaking this piece off from using Users and using Fake Users? Is that a possibility?