How to do end-to-end analytics?

Question

MySQL

Hello, tell me how to make reports like in Yandex Metrics or Roystat with a drop-down custom cut
Example:

I already did something similar, but I took everything out of my head. Where can you read about this? I need to do more functions, but I don't know how yet... (manually enter receipts, expenses, grouping by dates, complex relationships, etc..) I

use vue js