Extracting values causes duplication

[dinosainsburys]

For some context, I am pulling data from an API which lists the CPU usage on an hourly basis. There is 72 records in the date and values column, or at least there should be when I expand it.

However, I get 730 rows when I just expand the date.

This is the JSON format:

Any ideas? Spent far too long already trying to get it to match

[PhilipTreacy]

@dinosainsburys 

Why are you expecting 72 records?  NOTE a Record has a special meaning in Power Query as it's a data structure so I assume you mean rows of data.

That JSON shows 5 data points per response so I'm assuming each list in the Timestamps and Values column contains these.  Extracting the data in the ists will giev you as many rows as there is data.

What is your expected final result/what does the table look like at the end?

Regards

Phil

[dinosainsburys]

Sorry if I am not making sense, I think I would expect 730 rows in actuality. So when I expand the timestamps column, it brings out 730 rows which is correct based on the fact that there is chronological hourly timeline.

However, I have noticed when expanding the results.data.values, it then duplicates it 

 

There should only be one data value for each timestamp but now get multiple duplicate values which isn't right. When I use a visualisation on this dataset, I then just get a solid static line which of course isn't accurate. 

Any ideas, appreciate the response 🙂