1 of 1 people found this helpful
Your data format is not 100% clear to me, but my hunch is that you want to reshape your data.
For example, in the Tableau png you posted, you have measure names (comp_title1, comp_title2, ...). Usually, this isn't ideal. instead you'd want to plot the value and put comp_title_name on the color shelf. you can do this if you make your data "tall" instead of "wide". (Tableau generally works best with tall data, but data generated for humans is often wide.)
A tall version of your data might look like:
title comp_title_name value
book life of pie 15
book 50 shades 20
book lord of the rings 25
Tableau has an Excel plugin for reshaping data or you can automate it with custom SQL.
It's not clear to me where the titles "life of pie" are stored in your dataset.
If you can post some sample data and/or packaged Tableau workbook (twbx), it should be straight forward to get you what you need.
Thank you very much Jim. I've re-arranged the data as you suggested and it works perfectly now! Thank you for your time!