2 of 2 people found this helpful
Create these three separate calculations. Let me know if this helps.
TRIM( SPLIT( [Products], ";", 1 ) )
TRIM( SPLIT( [Products], ";", 2 ) )
TRIM( SPLIT( [Products], ";", 3 ) )
Thanks so much! This acts similarly to the Split function on the Data Source tab. How can I then use the multiple columns to have one overall column where each product counts as 1? You can see what I'm trying to accomplish in the attached workbook (I've re-uploaded another version) on the Products Tall worksheet. If I split each column, I end up with the Products Wide when I re-combine them or keep it the same.
Robert's suggestion will create new columns but there is no good way to unify those columns for analysis. You're going to need to re-shape your data to be tall, which makes product-level analysis easy, and then use an LOD expression to avoid double-counting total quotes and locations. TWBX attached.
ProductsSample_ZL.twbx 13.7 KB
1 of 1 people found this helpful
If you fix Support ID in Product Tall you can use the LOD expression from my workbook.
Thanks, Zach. That will work for me!