KNOWLEDGE BASE

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


Published: 17 Nov 2020
Last Modified Date: 18 Nov 2020

Question

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

Environment

  • Tableau Desktop
  • Tableau  Prep Builder

Answer

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?