How can I create a 'dashboard' with varying queries on one layout?
Hello - I have created a sales activity database that includes account detail, rep assignments, marketing events, etc. I would ultimately like to create a dashboard-like view for some information within the database.
For example, on one screen I'd like to see information such as the total number of active accounts in the system, the current quarter forecast, upcoming events, etc. Some of this information is related to other data, whereas some is in a table on it's own. To get a single view of this detail, I would effectively have to create multiple queries and display the results in various regions on the layout.
Does FileMaker support this? I can imagine doing this in a custom web page with ODBC queries back to the database, but I'd rather do this within the FileMaker application.