Quick poll: when someone says “matrix report”, what's your first reaction?

If it's a small flinch — you're not alone 😅

Matrix reports have a reputation. They sound advanced. They look complicated. And lots of folks (even seasoned Workday admins!) admit they've avoided building one for years, leaning entirely on Advanced reports instead.

So in this issue, we do what we do best — demystify it 🌤️ — to give you the confidence and clarity you need to start to unlock this side of Workday reporting.

Here’s what we’re covering:

  • Define what a matrix is

  • Tour the Matrix tab and meet its three main knobs

  • Build a simple Matrix report together, step by step

  • Layer in a second grouping to see what makes a matrix a matrix

  • Talk about when you'd actually whip up a Matrix report in real life

Let’s get into it 📊😃

P.S. "A safe intro to Matrix reports" is the #1 most-upvoted topic in the Premium content request portal 📦 You asked, and we built it for ya! This kicks off a whole Matrix Reporting series, so pour yourself your favorite beverage — we've got ground to cover ☕

This is where the good stuff lives.

Free builds awareness. Premium fills all the gaps 🦄

Plus everything else in Premium:

⭐️ Release Ratings & Reviews
🔐 Full archive access
🗳️ A say in what gets built

As always, thank you for being a reader!

We’re celebrating you and your unicorn status 🦄

Until next time,

the Well Built Team 🌞🏗️

Reply

Avatar

or to participate

Avatar

Diego Montano6 months ago

Really well-written and VERY informative. Thank you for this. One thing I noticed is that the Blanks not only group the workers that don't have a Management Level on their Job Profile, but also the ones that have multiple positions, even if those multiple positions have Job Profiles WITH Management Levels. Maybe it's just a matter of selecting a different field for the 'Group by Field' row grouping. I'll play around :)

Avatar

Ceci BlombergAuthor6 months ago

Amazing! So glad you found this issue helpful AND enjoyable, Diego!

On the blanks — interesting find. Definitely play around. The field used in this example is an indexed Data Source-friendly field, and from the looks of it, should pull in their management level based on their primary position if they're in multiple. If that's not happening in your tenant (Workday does have quirks like that), you could try using the plain ole non-indexed field "Management Level" or creating a LRV calc field that uses primary position as the lookup field and pulls back the management level as the return. Depends on your goals. Happy problem-solving! 🤓

Avatar

Demetrio the Wizard 🧙‍♂️6 months ago

The days of exporting everything to Excel for a quick pivot are ... counted😅

Thanks this was helpful, especially the point about rows as types of things vs. instances of a business object. My mental model is adapting to the idea it's a matrix of types.

Looking forward to the rest of the series!

Avatar

Ceci BlombergAuthor6 months ago

It's about time the excel method got an expiration date! ⏳ Heck ya, Demetrio.

Avatar

Josh6 months ago

Great article—and perfect timing for my organization! We recently moved a couple of HRGs into new roles where they’ll be taking on some Workday reporting responsibilities. This serves as an excellent introduction to matrix reports, which are ideal for org-wide reporting and data visibility.

Avatar

Ceci BlombergAuthor6 months ago

Amaaazing. And, these concepts will feed right into Discovery Boards, which could be an even better option for your HRGs 🤓

Avatar

Oscar Manuel6 months ago

Wow, clearly articulated. I've always avoided Matrix Reports. This is great!

Avatar

Ceci BlombergAuthor6 months ago

Wahoo! That's what we like to hear! Just wait 'til you finish the series... you're gonna step right into these without any trepidation.

Avatar

Josh6 months ago

💪