Count equals values in different column

[lukeert19]

Hello to all,

I need other help from this fantastic community ;), In my database I have those column:

SerialL3  => from this value normally I get the total row in a table

Shipping date => for find the month 

Part excenged 1

Part excenged 2 

Part excenged x (last values is 10)

I don't have an idea to how I can create one table with all specific below:

Find all parts excenged in different column end put in a column( without duplicate values)

Count how many times appear the parts in this table

End visualize the total quantity for each part excenged per month 

Thanks  for all supports

Luca 

[lorenzoconforti]

Hi Luca

Could you please put this in an excel file with a few rows of data and the output you expect so that it's easier to understand what you are looking for?

Also, are you looking to make these changes to the loading script or in the visualisation charts?

[lukeert19]

Hello Lorenzoconforti,

in attached tou can see one axample with which data I have and below the execel file tou can see what I need to see 🙂

about where I want to make these changes, I prefer during loading the script if possible. and then traslate all visualisation charts

thanks Lorenzo