Displaying Task Status in Matrix Report

[JohnMi]

Hi,

I’m trying to display task statuses in the matrix report below. I have projects as rows and tasks as columns. Below the image is an example of how I’d like it to appear. Once the status names are visible, I’m confident I can handle the color portion.

I tried creating a custom field to translate the status into a number:

IF({DE:Status}="NEW", 0, IF({DE:Status}="INP", 1, IF({DE:Status}="CMP", 2, 0)))

My goal was to display this field in the report. If I could get the value to show, I’d then use column rules to add color and select “show text.” See the screenshot below. However, I haven’t been able to get the value to display.

[skyehansen]

hi, according to workfront documentation, matrix reports will display numerical values only. Status can be shown as a sub header (see graphic).

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/create-manage-reports/c...

[johnmi11]

@skyehansenThanks for your response! I understand, but I was hoping there might be a workaround. For instance, I tried creating a custom field to translate the status into a number:

IF({DE:Status}="NEW", 0, IF({DE:Status}="INP", 1, IF({DE:Status}="CMP", 2, 0)))

My goal was to display this field in the report. If I could get the value to show, I’d then use column rules to add color and select “show text.” See the screenshot below. However, I haven’t been able to get the value to display.

Any suggestions?

Thanks!

[skyehansen]

that's not how matrix reports work. See the first line of the documentation, "Matrix reports present summary information..."

They don't show values in their intersecting cells. The data displayed is "summarized" in some way -- and you pick that way by selecting it when you bring in the column in your columns/view tab. You can summarize a field by: count, sum, average, min or max. So presuming you bring in your calculated status field, I assume you have to select "Sum" for showing it summarized in the matrix? But then I don't see how conditional formatting would work in this case.

[NishthaDu]

Hi skyehansen

For the matrix report grouping, Work Effort has been used. Instead of showing Small, Medium and Large, it is showing 1, 2 and 3. If I want to rename the current list, which is Small, Medium and Large or something else. Is it possible to display the actual names in the matrix report please? For reporting purposes, it is important that either the current list names are displayed or we have the functionality to rename them.

Nish