Return data from a specific time period

[caysle]

there is also this, however stupid it may look, gets me data since start and end of july, so one month ago and also will be updated as months pass by

issued_at >= date_trunc('month', current_date) - interval '1 month'
and issued_at < date_trunc('month', current_date) - interval '0 month'

I also need help with another subject, can you check?

PostgreSQL merge all tables together

I have four queries that brings data by network and a specific time period. I've done the math, now I need to visualize and put them together in a single query so they look tidy and accessible with a single query. Here are the result of these queries. How do I visualize them the best possible way? I've used LEFT JOIN to show these time periods in a table btw [2022-08-18 15_22_55-murat_kpi_metrics _ Editor _ Retool] [2022-08-18 15_23_18-murat_kpi_metrics _ Editor _ Retool] [2022-08-18 15_23_3…