Creating chart with aggregated data values
I'm creating a pie chart from a column where the number of days to resolve an issue could range from 1 to any number. In my chart, I'd like to aggregate the day values to: 1, 2, 3-5, 6-10 and More tha...
Forum Discussion
np,
Make a new formula text field called Issue Resolution Groups with the formula
IF(
[Issues resolution days] < =1, " 1"
[Issues resolution days] < =2, " 2"
[Issues resolution days] < =5, " 3-5"
[Issues resolution days] < =10, " 6-10"
[Issues resolution days] < =11, "11+")
Then base your chart in that field for the "series".
I have contrived the values with leading spaces to get them to sort properly.
Make a new formula text field called Issue Resolution Groups with the formula
IF(
[Issues resolution days] < =1, " 1"
[Issues resolution days] < =2, " 2"
[Issues resolution days] < =5, " 3-5"
[Issues resolution days] < =10, " 6-10"
[Issues resolution days] < =11, "11+")
Then base your chart in that field for the "series".
I have contrived the values with leading spaces to get them to sort properly.
Correction
IF(
[Issues resolution days] < =1, " 1"
[Issues resolution days] < =2, " 2"
[Issues resolution days] < =5, " 3-5"
[Issues resolution days] < =10, " 6-10", "11+")
IF(
[Issues resolution days] < =1, " 1"
[Issues resolution days] < =2, " 2"
[Issues resolution days] < =5, " 3-5"
[Issues resolution days] < =10, " 6-10", "11+")