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

    Questions on Filtering

    Aloysius Goh
      Share:|

      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,
      Aloysius