Reports:
In SmartVetApp Profit Diagnostix, every chart or table on a dashboard is based on reports. A report performs a query on the database. The result of this query equates to one data row. Depending what query is executed, the result can include one or more fields (columns) or can be empty.
There are also a few special types of reports, e.g. to perform calculations on results an variables (formulas) or to accumulate different rows to one big table or chart.
Variables:
Beside of database results, static values, dates and date ranges, staff or product names as well as ledger accounts and manual data points are required to represent a meaningful chart or table. All this of these values are kept in variables.
Variables always belong to a scope: Global, report and dashboard report. Additionally dashboard report variables can be overridden by a global variable and again by gobal global dashboard variables. This stack allows it to re-use the same report for e.g. different date ranges (like annual, monthly or weekly reports or different staff groups.
...
Each report can be assigned to one or more dashboards. Different output types per dashboard allows to chose the most meaningful can be chosen to display a changed representation of the data.
...
To create a new report click on "Settings" (top navigation) > "Reports"
Now a list of existing reports appears. Click on "Create new Report" (right navigation)
...