Forum Discussion
Average Cost Triangle/Triangulo de costo Medio
Hello Ibendlin
My output is the average of the cost column, it depends on the Open_Date and Charge data column, and I have to visualize it by quarter, for example I add what I would have to see in each box of the table, if it is not clear let me know:
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ||
| 2023 Q1 | January (Avg Cost Open_Date and Charge_Date January) | Febreary (Avg Cost Open_Date and Charge_Date January + February) | March Febreary | April (Avg Cost Open_Date (January + February + March) but Charge_Date (April) | May | June | July | August | September | ||||
| 2023 Q2 | April
(Avg Cost Open_Date and Charge_Date April) | May
(Avg Cost Open_Date and Charge_Date April + May) | June
(Avg Cost Open_Date and Charge_Date April + May +June) | July
(Avg Cost Open_Date (April + May + June) but Charge_Date (July) | August | September | October | November | |||||
| 2023 Q3 | July | August | September | October | November | December | |||||||
| 2023 Q4 | October | November | December | January (Next Year) | |||||||||
| 2024 Q1 |
My sample data is from only 5 months, but my actual data spans from 2020 onward.
I leave you images of what I have:
Open_date = Fecha_Ocurrencia
Charge_date = Fecha_Carga
Cost = Carga Siniestral
Thank in advance
- lbendlin
Super User
So for January you would want to ignore the entries that have a charge date in February?
