Hey everyone, This is my first post so unfortunately I cannot attach any links or images, hopefully I can describe it well enough.
I have a pivot table, which comes from audit logs.
The columns that represent different 'objects'.
The '50%' and '75%' etc columns are different 'options' within an option set on the object.
The '1' values simply show the that the option set was changed FROM this option on a date.
My end goal is to have a table displaying the average amount of days an object spent at each option for every option . For example:
10% | 3.4
30% | 5.8
50% | 7.9
75% | 17.4
...
It is also worth mentioning that the data is dynamic and over time, more objects and rows will be created.
Thank you for reading, does anybody have an idea how I could achieve this? If someone is able to point me in the right direction I would really appreciate it.
Bookmarks