Stack File Types in Projects Based on Project Completion Year for Column Report

[Jared_Mauch]

Workfront Community,

I've made a document report to track the various file types attached to projects with two groupings, the first is by project completion date and the second is by file type. In text mode it looks like:
group.0.groupdatesby=Y
group.0.linkedname=project
group.0.namekey=view.relatedcolumn
group.0.namekeyargkey.0=project
group.0.namekeyargkey.1=actualCompletionDate
group.0.notime=false
group.0.valuefield=project:actualCompletionDate
group.0.valueformat=atDateAsYearString
group.1.linkedname=documentVersion
group.1.listsort=nested(currentVersion).val(ext)
group.1.namekey=filetype.abbr
group.1.querysort=currentVersion:ext
group.1.valuefield=currentVersion:documentTypeLabel
group.1.valueformat=HTML
textmode=true

The details page of the report is fine, but I would like for the report to have a column chart with the x axis being the completion date by year and the columns show the different file types stacked. With my current groupings applied, I have Current Version >> (blank) as a grouping option for the columns. When I select that, the columns don't have the stacked file types per completion year. Did I do something wrong with my groupings or is stacking file types per project completion year not possible?

Thanks in advance,

Jared Mauch

[Madalyn_Destafney · Accepted solution]

Hi, are you in a document report?

I will tell you that text mode groupings do not work in chart groupings, unfortunately. So once you add text mode, you're still stuck with grouping your chart based on native options in the chart groupings of whatever report type you're in.