How To Count The Occurrence Of Values Separated By Comma In A Column

Published: 17 Nov 2020
Last Modified Date: 08 Jul 2022


How to count the occurrence of values separated by comma in a column


  • Tableau Desktop
  • Tableau  Prep Builder


1. Connect to the data using Tableau Prep Builder.
User-added image
2. Use custom splits for columns using "," to split into different columns in Tableau Prep Builder.
User-added image
3. Use pivot to pivot split column values into one 
User-added image
4. Output this to hyper and connect Tableau Desktop to it
User-added image
Did this article resolve the issue?