I want to have a simple dashboard record that can summarise information from one (or more) other tables. I want to count the records and total some fields. I have managed to make this work by including a field that I can use the rollup on, but this means in each new detail record I create, I have to link it to the summary record in the dashboard table.
Is there a way I can simply and automatically summarise data into may dashboard table which I want to have just the one summary record in?
Dashboard Table: 1 summary record
Columns: Total games played, Total time played, Total goals scored
Game Table: 1 record for every game
Columns: Date Played, Start Time, End Time, Time Played (date diff…), Goals Scored, Goals against, etc etc.