Hi all, has anyone built a project-level report that outputs a random selection of qualifying projects?

[stuartcairns]

So say I have a report that has a bundle of filters and it would normally produce a report showing 200 projects. If I want to show say 10% of these, chosen at random, how can I do that? I know Fusion has a random function but I cannot see how to do this in a Workfront report. If anyone has any ideas it would be great to hear them.

All the best, Stuart

[stuartcairns]

Used Random function from Fusion when programme is created.

[Kurt_Jones]

Stuart, I have a similar scenario.  A group would like to pull a random list of completed projects every month to a QA review.  What did you do in Fusion with the Random function?

In my situation I'll likely be reading completed project records for a specific timeframe (a month) then want to whittle it to a smaller, random list of those projects.