Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

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

Avatar

Level 3

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

If this helped you, please mark correct to help others : )

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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.

If this helped you, please mark correct to help others : )