Hi all, has anyone built a project-level report that outputs a random selection of qualifying projects? | Community
Skip to main content
Level 4
Sep 15, 2021 10:17 AM UTC
Question

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

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Level 4
Sep 20, 2021 1:29 PM UTC

Used Random function from Fusion when programme is created.

Translate
Kurt_Jones
New Participant
Aug 23, 2022 10:22 PM UTC

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.

Translate