Report/query 2 tables at once and sort by month on date found
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-31-2023 08:45 AM - edited 10-31-2023 08:46 AM
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!
Labels:
- Labels:
-
Reporting
0 REPLIES 0