I have the following query:
SELECT FECHA_MUESTRA DIA,
LABEL,
DL_OUT_TH_KBPS,
UL_INC_TH_KBPS,
ROUND ( (DL_OUT_TH_KBPS + UL_INC_TH_KBPS) / (1000 * 1000), 2)
TOTAL_DL_UL_GBPS
FROM V_GF_DATA_GW_TH_KBPS
WHERE FECHA_MUESTRA >= trunc(sysdate,'iw')
ORDER BY FECHA_MUESTRA ASC, label ASC
Where it brings me the data of the current week, what I want to do now is to be able to bring me the data of the last 5 weeks
Attached image of the result of the current query
You can subtract the number of days from the 5 weeks and then use TRUNC:
Greetings.