Multiple Line Chart to detect an outlier in the data
Hello, everyone, I would like to display two graphs with the following data structure.
Order
Material
Productgroup
Op
LeadTime
MonthYear
1
33
component
10
2
June 2020
1
33
component
20
3
June 2020
1
33
component
30
5
June 2020
2
25
component
10
1
June 2020
2
25
component
20
3
June 2020
2
25
component
30
2
June 2020
3
33
component
10
8
July 2020
3
33
component
20
9
July 2020
3
33
component
30
7
July 2020
4
25
component
10
2
July 2020
4
25
component
20
8
July 2020
4
25
component
30
6
July 2020
The first would be the average of the product group over time. The second would be the average of the individual material numbers over time. I will use the following formula for the average of the product groups.