1 Reply Latest reply on Sep 12, 2018 2:32 PM by Abhay Bagalkoti

    Questions on Filtering

    Aloysius Goh
      Share This:

      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.


      Best Regards,