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.
Hi there - Trying it now. I see the different clusters are on separate lines. Does that mean each one is it's own formula? If not, how do I separate [Issues resolution days] < =1, " 1" from [Issues resolution days] < =2, " 2" for example--comma? Thanks!