(ask) Fortianalyzer create custom report with postgress.schema

You may wish to start by using chart builder if you are unfamiliar with SQL.

But if you decide you want to learn SQL & customize datasets manually, you can study the predefined datasets for ideas.  The point of the schema is primarily to show you which fields are available for each log type.  Usually a dataset will only query a single log type.