Report/query 2 tables at once and sort by month on date found

tzvik15
Giga Contributor

Hello,

 

We were asked to create a report / query that will show tickets in 2 separate tables (change task, implementation task (this one is a custom table)), and group them by the month they were created.

 

I am able to run individual queries/reports against each of the tables, but do not know how to aggregate the data from both of them. Additionally, when I group by date, the grouping is displayed for each discreet date. Is it possible to group by month rather than by day?

 

Thanks!

0 REPLIES 0