Report Groupings: Text Mode Grouping shows up in Report Details, but Grouping does not work in Summary or Chart | Community
Skip to main content
Level 2
June 10, 2020
Question

Report Groupings: Text Mode Grouping shows up in Report Details, but Grouping does not work in Summary or Chart

  • June 10, 2020
  • 1 reply
  • 518 views

I'm creating an Issue report that groups first by the Resolve Project Owner and then by the Queue Topic Name on the issue. I've used Text Mode to do this grouping:

group.0.displayname=Resolve Project Owner

group.0.valuefield=resolveProject:owner:name

group.0.valueformat=HTML

group.1.linkedname=direct

group.1.namekey=Queue Topic Name

group.1.valuefield=Queue Topic Name

group.1.valueformat=customDataLabelsAsString

textmode=true

The Details report does this, but when I look at the Summary, it says the Resolve Project Owner = No Value. I created a Stacked Chart, where the Y axis is the record count and the X axis is similarly grouped, first by Resolve Project Owner, then by Queue Topic Name. The report groups the Queue Topics, but just creates a single column saying that the Resolve Project Owner = No Value.

See attached screenshots. Please help me out!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Community Advisor
June 11, 2020

Hi Daniel,

I suggest you add a calculated parameter to the Issues in question to capture and persist the Resolve Project Owner Name, and then adjust your report to draw the information from that "in the database" source, which might then yield the charting results you expect.

Regards,

Doug