CFO allows to show some reports of the data when then source is a SQL table.

Sample result

Definition

"reports" is the node under "interface" that start the report definition. A report contains:

"{table}":{
     "interface":{
        "reports": {
          "{reprort_id_1}": {
            "title": "Total in Accounts",
            "kpis": [
              {"dimensions": [
                {"field":"Deposit","formula":"FinancialDeposit_Name"},
                {"field":"Currency","formula":"FinancialDepositMovement_SourceCurrency"}
              ],
                "metrics": [
                {"field":"Total","formula":"sum(FinancialDepositMovement_SourceAmount)"} ]}
            ],
            "order":"FinancialDeposit_Name DESC"
          },
          "{reprort_id_2}": {
            "title": "Total in Cashflow",
            "kpis": [
              {
                "metrics": [
                  {"field":"Total","formula":"sum(FinancialDepositMovement_SourceAmount)"} ]}
            ]
          },
          ....
        }
    }
}

• dimensions: fields for rows
• metrics: field for columns
• where: optional where condition to be added
• order: optional field to apply a specific order
• limit: optional limit of results

View show

Once you have defined the reports, you hace to show them in the view

..
"view": {
   "default": {
      "name":"...",
      ...,
     "reports":["{reprort_id_1}","{reprort_id_2}",..],
     "fields": [...]
     }
  }"reports":["accounts","total"],