This content has been marked as final. Show 1 reply
Good Afternoon all,
I am a new user of BMC smart reporting here.
I am currently trying to create a report that shows Tickets that are open and closed as well as Total Tickets
I have created a union subquery for my closed ticket and my Open ticket as my master query as they are using different fields to filter their date.
So now I am wondering if I would to create another subquery for my Total Tickets, is there anyway I can add both the result from the previous query i have made or is there another alternative I could approach. As I would need a chart to show the total results hence I did not use total rows/columns.
Please Advice Thanks.