mlanterma Member

Hi @jaeW_at_Onyx Thank you for the terrific directions and suggestions. I was able to unpivot the data and split the dates into the column 'Status Date'. The ABC column is there because I could not figure out how to only take the 1/04/21 when splitting the original 'Item Status' in the ETL. Then I took your suggestion to…

I do not have any sorting set in analyzer. There are two filters, but removing them does not impact the issue. It only adds more items to each status across all status columns.

Hi, Thank you for the answers. The Concat worked for what I needed. For the date dimension table, would that be a static spreadsheet that I load into Domo and then join to whichever data flow requires?

Hello, Thank you both for the answers. I think the pivot table will be easiest for me to execute. I will flag the ETL as something I need to research and learn about. Data looks like this: The Item Status column is the status of items on 1/4/21 - and needs to be included in the total evaluation. The pivot table wont allow…