Utilizing the "Project Dashboard" in REDCap to create customized tables with recruitment data

I use REDCap for research human subject participant recruitment and data collection tracking - by creating a form that allows our research assistants to update according to a potential participants' status. For example, we have one variable might be "Participant Status" with three drop downs (In Progress, Enrolled, Not Participating).

My goal is to create a Project Dashboard that is useful for quick overview of project status. One of the primary ways I'd like to do this is by creating a dynamic table that represents some of these variables - something that would look like the following:

| | In Progress| Enrolled | Not Participating | | Group 1 | N (%) | N (%) | N (%) | | Group 2 | N (%) | N (%) | N (%) | | Group 3 | N (%) | N (%) | N (%) |

But I can't figure out the appropriate source code to use to create something like this. The example above would be two variables - outputting the "Participant Status" variable and then grouping by another variable.

I know about the REDCap generated options that sort of approximate the above. Like the Plots & Stats in the Reports section, or the Smart Tables in the Project Dashboard section. But those don't do exactly what I'm looking for as far as I can tell. So I was hoping there would be custom coding tips/tricks on how to accomplish the above. When I try to search for examples of table customization/calculating fields, it primarily brings me into the forms themselves on how to calculate new fields.

source https://stackoverflow.com/questions/77462128/utilizing-the-project-dashboard-in-redcap-to-create-customized-tables-with-rec