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
