×Sorry to interruptThis page has an error. You might just need to refresh it.
Unable to find an action for 325;a: {"id":"325;a","state":"SUCCESS","returnValue":{"componentDef":{"descriptor":"layout://rl-User-VIEW-FULL----force_highlights-_1-0-674b574567657471726c42666756465a66576b5766673d3d.c"},"original":"markup://force:recordLayout","creationPath":"/*[0]","attributes":{"values":{"mode":"VIEW","offset":0,"inContextOfComponent":"force:highlights","isDraft":false,"record":{"LastModifiedDate":"2025-02-06T20:29:30.000Z","Email":null,"FirstName":"Jonathan","AboutMe":"I use Tableau by day and write about Tableau by day and night.","PostalCode":null,"Title":null,"City":null,"MiddleName":null,"Name":"Jonathan Drummey","SystemModstamp":"2025-02-06T20:29:30.000Z","CompanyName":"PATH","CommunityNickname":"jonathandrummey","Suffix":null,"Phone":null,"State":null,"CreatedDate":"2020-04-25T13:26:52.000Z","Street":null,"Country":null,"LastName":"Drummey","Id":"0054T000001O4jxQAC","LastModifiedById":"0054T000001N0mYQAS","sobjectType":"User"},"pageSize":-1,"type":"FULL"}}},"error":[],"components":[{"componentDef":{"descriptor":"layout://rl-User-VIEW-FULL----force_highlights-_1-0-674b574567657471726c42666756465a66576b5766673d3d.c"},"original":"markup://force:recordLayout","creationPath":"/*[0]","attributes":{"values":{"mode":"VIEW","offset":0,"inContextOfComponent":"force:highlights","isDraft":false,"record":{"LastModifiedDate":"2025-02-06T20:29:30.000Z","Email":null,"FirstName":"Jonathan","AboutMe":"I use Tableau by day and write about Tableau by day and night.","PostalCode":null,"Title":null,"City":null,"MiddleName":null,"Name":"Jonathan Drummey","SystemModstamp":"2025-02-06T20:29:30.000Z","CompanyName":"PATH","CommunityNickname":"jonathandrummey","Suffix":null,"Phone":null,"State":null,"CreatedDate":"2020-04-25T13:26:52.000Z","Street":null,"Country":null,"LastName":"Drummey","Id":"0054T000001O4jxQAC","LastModifiedById":"0054T000001N0mYQAS","sobjectType":"User"},"pageSize":-1,"type":"FULL"}}}]}
Hey @Anonymous User (Member) I agree with Jim that a workbook would make it easier to answer your question, but I thought I might add some thoughts I had. I'm guessing you have a filter that shows only subrequests at 100% but that doesn't filter to only team members with all subrequests at 100%. From what you've shared, I would suggest two filters. The first to find team members who've completed all their subrequests:
{ FIXED [team member] : SUM( IF [sub request number] < 1 THEN 1 ELSE 0 END)} = 0
The above level of detail (LOD) calculation finds has two parts. First the IF THEN statement assigns 1 for every subrequest not at 100%. Then the FIXED statement sums up the IF THEN for all subrequests for a team member. If any team member has a value of 1 or higher than they have uncompleted subrequests.
Note: the above syntax may need to be modified for the structure of the data. My suggestion assumes that the underlying data set has one (and only one) record for every subrequest.
Then, you need a filter for most recent date:
{ FIXED [team member] : MAX( [Date] )}
If none of those steps resolve the issue, then please upload a sample packaged workbook (*.twbx) file demonstrating the issue. A quick way to anonymize workbooks is to hide any fields with sensitive data before extracting the data source. Otherwise creating 2-3 rows of dummy data is typically sufficient.
Hope that helps!
Esther Aller
If I helped, please mark the question as answered :D