You must be able to construct valid query strings with Structured Query Language (SQL).
In the Console, navigate to Reports then Custom Reports.
Select Global Actions > Create Custom Report.
Define the report properties and query string as desired.
In the Report properties section, specify the report name, summary, description, and category.
In the Report query section, input your SQL query string.
For further information on the data schema, click Help in the report window or refer to Platform Symphony Reports Data Schema in the Platform Symphony Knowledge Center.
To validate your SQL query string and ensure that your report delivers the appropriate results, click Produce Report.
This will actually produce the report, so you might want to limit your testing to a small set of data.
You can continue to edit your SQL query string and test the results of your report until you are ready to save it.
To finish, click Create.
To access your new custom report, navigate to Reports then Custom Reports.