I want to find the average of fs_lbs_per_hr for the month
and the totals for the other column for the month. when I try to do
it by month it still shows the days. for example, for dates there
should only be one 2022-03-01.
I Want To Find The Average Of Fs Lbs Per Hr For The Month And The Totals For The Other Column For The Month When I Try 1 (58.51 KiB) Viewed 24 times
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 SELECT fs_pallets_per_hr fs_lbs_per_hr fs_pallets_received fs_pounds_received fs_labor_hours --, date ,date_trunc( 'month', date)::timestamp as dateFY ,date_trunc( 'month', date)::date as date_full from dev.warehouse_metrics --WHERE date = CURRENT_DATE WHERE date BETWEEN {{moment(overallDatePicker.startValue).format("YYYY-MM-DD")}} and {{moment(overallDatePicker.endValue).format("YYYY-MM-DD")}} GROUP BY datefy --date fs_pallets_per_hr ,fs_lbs_per_hr fs_pallets_received ,fs-pounds_received fs_labor_hours ORDER BY datefy DESC 1 .