Text Mode Grouping Help - Custom Grouping & Labels for Ranges | Community
Skip to main content
LaramieNewbs
New Participant
August 12, 2024
Solved

Text Mode Grouping Help - Custom Grouping & Labels for Ranges

  • August 12, 2024
  • 1 reply
  • 491 views

I have a report in which I have a custom calculated field on to calculate the Weekday Difference between Entry Date and Actual Completion Date. I have this custom calculated field formatted as a number. 

 

I need to group by this field on a report (0-10 days, 11-30 days, 30+ days) so that I can pull it into chart. My other groupings are working but this one is not (group.1 below). 

 

The goal is to create a chart that shows the range of days to complete and the maximum days to complete and is grouped by team on the chart.

 

group.0.iscollapsed=false

group.0.linkedname=team

group.0.namekey=view.relatedcolumn

group.0.namekeyargkey.0=team

group.0.namekeyargkey.1=name

group.0.valuefield=team:name

group.0.valueformat=string

group.1.linkedname=direct

group.1.namekey=Time to Complete Request

group.1.valueexpression=IF({Time to Complete Request}<11,”0-10 Days”,IF({Time to Complete Request}<31,”11-30 Days”,IF({Time to Complete Request}>30,”30+ Days”)))

group.1.valueformat=doubleAsString

group.2.linkedname=direct

group.2.namekey=Time to Complete Request

group.2.valuefield=Time to Complete Request

group.2.valueformat=customDataLabelsAsString

textmode=true

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

1) To do the Valueexpression you would need to include the DE: for the fieldname

2) You cannot do a grouping in the report to display on the chart. That needs to be a custom field

 

 

1 reply

GrahamJarrett
GrahamJarrettAccepted solution
New Participant
August 12, 2024

1) To do the Valueexpression you would need to include the DE: for the fieldname

2) You cannot do a grouping in the report to display on the chart. That needs to be a custom field