1 year ago
#260744
Marcelo Bastos
Plot number of tickets opened and closed by month in R
I have a list of tickets and I would to create a graph to show how many opened and closed by month.
Every ticket item has 2 data points: opened_at date and closed_at date. I want to create a clustered Column Graph by month.year.
Every month.year's should display 2 columns: a) quantity of opened_at items and b) quantity of closed at items:
Item opened_at closed_at
Ticket 1 22/02/2020
Ticket 2 22/02/2020
Ticket 3 22/02/2020 22/02/2020
Ticket 4 22/02/2020
Ticket 5 12/02/2021
Ticket 6 12/02/2021 11/04/2022
Ticket 7 12/02/2021
Ticket 8 09/02/2022
Ticket 9 07/02/2022
Ticket 10 03/02/2022
For the Graph: by month year example: 01.2022 (Jan 22), 02.2022 (Feb 22), and so on...]
The X-axis should display every month in sequence, and the Y-axis should display the quantity.
I used tably to summarise items by date (by month) and it has been the further I could get.
r
ggplot2
clustered-index
0 Answers
Your Answer