Forum Discussion
Calculate AVG by type of product and group by month
Hi all,
Any help how can i get the result on below table based on image attaches?
The pretented result:
| Month | AVG (LeadTimeOfTypeFL) | AVG (LeadTimeOfTypePH) |
| 1 | 7 | 15 |
| 2 | 15 | 25 |
Thank you
- Month 2: So year 2024 vs 2025 don't matter for the result?
- don't matter for the result.it consider on the basis of months
This should work for you:
SELECT MONTH(T.Date) AS Month, AVG(CASE WHEN T.ProductType = 'FL' THEN T.LeadTime ELSE NULL END) AS LeadTimeOfTypeFL, AVG(CASE WHEN T.ProductType = 'PH' THEN T.LeadTime ELSE NULL END) AS LeadTimeOfTypePH FROM yourTable AS T GROUP BY MONTH(T.Date)
- hi,
you can use this code
SELECT Month,
MAX(CASE WHEN ProductType='FL' THEN avg END) "AVG LeadTimeOFFL",
MAX(CASE WHEN ProductType='PH' THEN avg END) "AVG LeadTimeoFPH"
FROM (
SELECT MONTH(DATE) Month,ProductType,AVG(LeadTime) avg FROM ProductTable GROUP BY MONTH(DATE),ProductType
) as fdfdf
GROUP BY Month;
use your table name instead of 'ProductTable' as table name
