[PdrDashboard] Reduce and improve db queries

[KatunaNorbert]

Background / motivation

Reduce number of queries to the db so we can more efficiently use date period filtering

TODOs / DoD

• [ ] identify duplicate query values and try to reduce number of queries to the db