Skip to main content
Question

Creating chart with aggregated data values

  • December 29, 2017
  • 0 replies
  • 57 views
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 than 10. My number of days field property is numeric. I've tried creating a calculated column but am having trouble with the formula. I tried an "If" formula with a series but that didn't work. Any suggestions?
    This topic has been closed for replies.

    • KevinOBoyle
    • Registered
    • December 29, 2017
    did you try a case statement?
    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.
    Terms & ConditionsAccessibility statement