Convert list to table for graph

[ajd33]

Hi there,

I currently have a custom column that groups each associates' total revenue sorted by date. For instance, in the "Total Revenue Custom" column, this has multiple lists for each associate showing their total revenue ordered by the date in which they started. For the purpose of explanation, you can see in the screenshot Month 1 Total Revenue is 0.788; Month 2 Total Revenue is 0.714 etc for that particular associate.

What I wanted to do is to visualise this data. This means that I want all associates' Month 1's total revenue, all associates' Month 2's total revenue data on a line chart. As people started in different months, I felt this was the only way to standardize everyone's data to ensure it is Month 1, Month 2 (any other ways to achieve this would also help!).

However, as I have lists in each cell, I have no idea how I can convert this to a column that has Month 1 which then shows the first row of the list for each associate, then I can do this for Month 2 (with the second row from each associates' lists) etc. 

Any help in getting to my solution would be much appreciated 🙂 

[v-chuncz-msft · Accepted solution]

@ajd33 ,

It seems that you may change type number to list in the code.