Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Level 4

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies

Avatar

Level 3

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.