To create your own reports, you can use Microsoft Power BI Desktop application along with the Frontu API connector, which will allow you to download all the necessary information.
Here are the steps to set up the integration:
Download Microsoft Power BI Desktop from the PowerBI desktop website.
Download Frontu API Connector
Open the connector file with the Power BI Desktop application
Enter your Frontu account details:
Wait while all your account information is downloaded
You will see all possible entities and fields in the "Fields" tab.
Create your own reports using tools provided by Microsoft Power BI Desktop software.
Quick tips for Power BI usage:
All dates are displayed in UTC (+0) time zone, if your reports are time/date specific, you need to create separate columns for required fields with the “Local time” option.
If you’re using custom fields, you must expand the “customValues” column on each table. Expanded columns will have GUID identifiers. To identify a custom field, you can find the custom field guid in its preview on the Frontu administration panel: