Hi all, has anyone built a project-level report that outputs a random selection of qualifying projects? | Community
Skip to main content
S
stuartcairns
Level 4
September 15, 2021
Question

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

  • September 15, 2021
  • 1 reply
  • 573 views

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.

1 reply

S
stuartcairnsAuthor
Level 4
September 20, 2021

Used Random function from Fusion when programme is created.

Kurt_Jones
Community Advisor
Kurt_JonesCommunity Advisor
Community Advisor
August 23, 2022

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.

Terms & ConditionsAccessibility statement

Loading footer...