Good day Developers? I am in need of a one on one coach that will teach how to build Filemaker dashboards without using any 3rd party software! Any expert out there?
Kindly note this will be done online as i am from namibia
What kind of dashboard? What features?
Describe your project please. What are the existing tables, maybe a screenshot of the Relationship Graph will help.
What kind of information do you want to display on the dashboard. Every dashboard is different.
Maybe a sketch will help, showing just with squares and rectangles different areas. In each area, define the data that will be shown like Navigation: Buttons to jump to different layouts, etc...
There are several free projects that you could use to learn the tricks of the trade. Once of them is FMStartingPoint from richardcarltonconsulting (I apologize for not naming other solutions but they don't come to mind right now.)
When I started working with Dashboards, I used this video to refer to:
FM Academy - How To Create Dashboards with FileMaker Pro - YouTube
It comes down to what you want to show on the screen.
For some reason, a long time ago, I bought the book Information Dashboard Design: The Effective Visual Communication of Data as a general concept understanding of dashboards and displaying data.
I have an Office Expenses Report that can be sorted by year, month, category
I currently have 6 charts, 2 sorted by Year, 1 sorted by month and 3 sorted by category
However, this charts are not on the same layout because if I put them on the same layout and I sort by year, the others sorted by category and month won’t show accurate results anymore.
Attached is my charts on pdf, Kindly note page has yearly charts on the same layout, page 2 has a month chart, and page 3 has categories charts
My question is, how do I put them on the same layout and still show accurate result?
A dashboard consists of multiple portals or charts or web viewers that show data somewhere from your file.
The 'somewhere' can be a virtual list or an ExecuteSQL result or a related table.
The data can come from an actual table with all the records, or it can come from a summary table.
Just place the objects on the layout and get the data to them in any number of ways.
Retrieving data ...