Is there a way to compute product correlation with refreshing order IDs in tableau or Excel?-CodePudding

I have issues with cleaning my data. 1 year of sales data provided —> sales data only provided quantity sold.

order id refreshes every day. Starts from 1
some orders may purchase just one item, but some have more than one item

The example illustrates the number of items sold on 2nd Jan 2020 and there are a total of 168 orders for that day. When 3 Jan 2020 starts, the order id is refreshed back to 1.

CodePudding user response：

If you want a unique order ID then something like combining the date and order ID will do it for you, it just needs to be placed into a new column ...

=TEXT(D2,"yyyyMMdd") & TEXT(B2,"00000")

This will, you retain your original data but have the unique order ID to filter on if need be.