Forum Discussion
Solved
Assigning generic name to user
Hi, I have 2 users performing audits every week, but the username is different every week. I am not interested to show who did the audit, but I need to have the result for each auditor. Is there a w...
I think I found the mistake:
countx(filter(Table,[Week] = earlier([Week]) && [Index] <=earlier([index])),[Index])
thanks a lot!
Hi and thanks for your quick reply! I implemented the formula but this is giving me always "Auditor 2" because is counting the number of auditors in that specific week, but I need, for example for the week 1, that in the line of "Ronny" I get "Auditor 1" and in the line of "Martin" I get "Auditor 2"
I think I found the mistake:
countx(filter(Table,[Week] = earlier([Week]) && [Index] <=earlier([index])),[Index])
thanks a lot!