Not sure where the problem starts?

That is normal. Most analytics problems show up as dashboard frustration, but the root cause is often definitions, governance, operating cadence, or delivery model.