'Sum specify rows in a data frame
I created a summary for my data and worked out percentages of occurrences per category. Now, I want to sum a subset of categories to show their value combined. For example, I want to be able to say that 51.1% of all occurrences are within the categories 30, 60, and 120 days (sum of rows #6, #9, and #3). The name of the Data.frame is "Summary_2".
Category Count Percent
1 1 day 4 3.3%
8 5 days 5 4.1%
4 180 days 8 6.5%
5 240 days 9 7.3%
2 10 days 15 12.2%
3 120 days 18 14.6%
6 30 days 19 15.4%
7 360 days 19 15.4%
9 60 days 26 21.1%
This is a summary of tickets. I arbitrarily want to say that 50% of our tickets are resolved within 2 months, 30% are resolved from 180 to 360 days, and 20% is resolved within 10 days.
In Excel it looks like that:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|