Expand my Community achievements bar.

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.

2 Replies

Avatar

Level 4

Used Random function from Fusion when programme is created.

Avatar

Community Advisor

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.