Forum Discussion

CraigC's avatar
CraigC
Helper I
9 years ago
Solved

Create a pie chart from counting values in different ranges

 Hi Everyone   I need to create a pie chart from the resolution times column.   I have calculated the resolution time from open time to close time using the following formula: Resolution Time = ...
  • fhill's avatar
    fhill
    9 years ago

    I'll skip my many personal objections to the pie chart for now...  but I think this was what you were going for...?  I changed your 'Under 15 Min' to '0-15 Min' to make sorting easier...  Hope this helps, FOrrest

     

    Graph = IF(Table1[Resolution Time] < 0.25,"0-15 Min",
    IF(Table1[Resolution Time] >= 0.25 && Table1[Resolution Time] < 0.5,"15-30 Min",
    IF(Table1[Resolution Time] >= 0.5 && Table1[Resolution Time] < 0.75,"30-45 Min",
    IF(Table1[Resolution Time] >= 0.75 && Table1[Resolution Time] < 1, "45-60 Min",
    IF(Table1[Resolution Time] >= 1,"Over 1 Hour","Error")))))

     

fhill's avatar
fhill
Resident Rockstar
9 years ago

I'll skip my many personal objections to the pie chart for now...  but I think this was what you were going for...?  I changed your 'Under 15 Min' to '0-15 Min' to make sorting easier...  Hope this helps, FOrrest

 

Graph = IF(Table1[Resolution Time] < 0.25,"0-15 Min",
IF(Table1[Resolution Time] >= 0.25 && Table1[Resolution Time] < 0.5,"15-30 Min",
IF(Table1[Resolution Time] >= 0.5 && Table1[Resolution Time] < 0.75,"30-45 Min",
IF(Table1[Resolution Time] >= 0.75 && Table1[Resolution Time] < 1, "45-60 Min",
IF(Table1[Resolution Time] >= 1,"Over 1 Hour","Error")))))

 

CraigC's avatar
CraigC
Helper I
9 years ago

I know, but people like the "pretty wheel".

 

Worked perfectly! Thank you:)