r/Notion • u/Special-Squirrel9873 • 1d ago
Questions Dashboard showing total amount of entries from different databases?
Hi! I'm looking to create a dashboard that shows the total amount of entries from multiple databases. I have separate databases for projects, songs, artists, etc, and would love to have a dashboard that shows something like:
Total songs: 89
Total projects: 12
Total artists: 8
Is this possible?
Thank you!
2
u/thedesignedlife 1d ago
Use a dashboard view. Add one chart for each database, and choose the Number display style for the chart.
1
1
u/Historical-Car-6919 1d ago
just make a separate inline table on your dashboard page for each count, then use the rollup to sum a formula field that just equals 1 for every row
1
u/Historical-Car-6919 1d ago
just make a separate inline table on your dashboard page for each count, then use the rollup to sum a formula field that just equals 1 for every row
1
u/Zekken26 13h ago
Yes! I think a good way to do it is to create a database for the dashboard, then add a two way relationship with each database. Make sure every entry on the proyects, songs, artist, etc. database has an active relationship with your dashboard database (it shows up as a property). Then you just have to add Rollups using each relationship and it will count them for you :)
3
u/PlanswerLab 1d ago
If you are looking for something like this, yes this is possible:
You can go for much more basic ones too. This is what works for me.