[R] Grouping by Date and showing count of failures by date

Paul Bernal p@u|bern@|07 @end|ng |rom gm@||@com
Fri Sep 29 22:29:13 CEST 2023

Dear friends,

Hope you are doing great. I am attaching the dataset I am working with
because, when I tried to dput() it, I was not able to copy the entire
result from dput(), so I apologize in advance for that.

I am interested in creating a column named Failure_Date_Period that has the
FAILDATE but formatted as YYYY_MM. Then I want to count the number of
failures (given by column WONUM) and just have a dataframe that has the
FAILDATE and the count of WONUM.

I tried this:
pt <- PivotTable$new()
pt <- PivotTable$new()
pt$defineCalculation(calculationName = "FailCounts",

but I was not successful. Bottom line, I need to create a new dataframe
that has the number of failures by FAILDATE, but in YYYY-MM format.

Any help and/or guidance will be greatly appreciated.

Kind regards,

More information about the R-help mailing list