Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
sum(aggr(avg(LeadTime), Op, Productgroup, MonthYear))
how can I use this formula to display material numbers? I want to see many individual lines. The following approach was not working.
sum(aggr(avg(LeadTime), Op, Material, MonthYear))
I want to get something like this:
Thanks in advance!