1 of 1 people found this helpful
Your data is structured as a wide table - Tableau and other d/b orient programs work best with tall tables
Consider pivoting the data (see the link Pivot Data from Columns to Rows )
you will have nulls in the data but you have them already - they can be filtered out easily
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
IF Referral 2 = Preschool
IF Referral 3 = Preschool
and so on
Thanks Jim -- was unaware of the power of Pivoting your own data within Tableau! That worked perfectly.
Thanks Kevin -
Tableau and excel are fundamentally different and each has its own uses - structuring the data as tall thin tables will allow you to use a broader level of the Tableau capabilities
- eg table calculations, pages and uses simple filters in your viz's
if that provided a solution please mark my response helpful or correct