Parent Ticket Details + Child Ticket Volume by Month Created

[Anonymous]

Hello,

I have two data sets which are related. A Parent Ticket set which includes a unique ID. And then a Child Ticket set of which each are related to one of the Parent Tickets. I have a one-to-many relationship set up from Parent to Child data sets.

Example of the data:
Parent Ticket

Unique ID, some data, some data...

Child Ticket

Unique ID, Create Date, Parent Ticket

What I want to display is some info from the Parent Ticket Data set, and then a column for each month representing the volume of related Child Tickets, by the Month in the Child Ticket Create Date.  

Desired result:
Parent Ticket ID 001, some data, Child Ticket Volume January, Child Ticket Volume February, etc...
Parent Ticket ID 002, some data, Child Ticket Volume January, Child Ticket Volume February, etc...
Parent Ticket ID 003, some data, Child Ticket Volume January, Child Ticket Volume February, etc...

I think I may be able to do this by adding 12 columns for the months to the Parent Ticket data, and then some code to count "COUNT DISTINCT WHERE Child Ticket Create Date = "month" ". I wonder if that is the correct approach and how to do it, or if there is an easier way?

[Anonymous · Accepted solution]

I found a solution. I used a Matrix, added all the parent ticket fields to Rows, child ticket Created date to columns, and then Count(distinct) child ticket ID to Values. 

In child ticket Create date in columns, delete quarter and day. Filter Year to be 2023. Then delete year from columns, leaving only month (the year filter stays on!) which leaves the month columns.

Then for every single field in Parent Ticket, expand level, and then in format, hide the +/- symbols.