Filtering to a percentage of issues with a specific form response

[ElizaBa]

I don't even know if this is possible and I hope I can explain it well.

I am trying to create a report to audit documents approved by different people. We are required in our industry to audit 20% of documents submitted the previous month by each of our approvers to ensure they are meeting requirements and give them extra training as needed. 

let's say in the previous month, I approved 10 documents.

Doc Num | Approver | Approved Date

1 | Eliza Barry | 1/1/2024

2 | Eliza Barry | 1/2/2024

3 | Eliza Barry | 1/3/2024

4 | Eliza Barry | 1/4/2024

5 | Eliza Barry | 1/5/2024

6 | Eliza Barry | 1/6/2024

7 | Eliza Barry | 1/7/2024

8 | Eliza Barry | 1/8/2024

9 | Eliza Barry | 1/9/2024

10 | Eliza Barry | 1/10/2024

I would like to get the first 2 rows in my report, representing a 20% sample

Doc Num | Approver | Approved Date

1 | Eliza Barry | 1/1/2024

2 | Eliza Barry | 1/2/2024

bonus points if it can be random

even more bonus points if the count of total submission in the period as a column as well:

Doc Num | Approver | Approved Date | Submission in Pd

1 | Eliza Barry | 1/1/2024 | 10

2 | Eliza Barry | 1/2/2024 | 10

I'm grateful for any help!

[Sven-SC]

Hi @ElizaBa 

The only way you can do is by using Fusion. There is no such provision to show "random 20% of rows". There's also no way to display total count of a set that includes items (the other 80%) not displayed on the report.

[Doug_Den_Hoed__AtAppStore]

Hi @ElizaBa,

I have an idea, but need to do a bit of experimenting to confirm it will meet your requirements.

I will post an update (either way) at my earliest opportunity.

Regards,

Doug