Thanks in advance to reading this. So I have this problem where my data is down to one row per customer. It makes the analysis easier (at least to what I am used to). The downside is that there is no date column to trend the data on. This data is held up in separate columns.
|customer||Customer start date||month 1 purchase count||month 2 purchase count||month 3 purchase count||month 4 purchase count||month 5 purchase count||month 6 purchase count|
Ideally, my data would look like this to work:
|month 1 purchase count||John||2|
|month 2 purchase count||John||8|
|month 3 purchase count||John||5|
|month 4 purchase count||John||9|
|month 5 purchase count||John||6|
|month 6 purchase count||John||5|
|month 1 purchase count||Jane||2|
|month 2 purchase count||Jane||4|
|month 3 purchase count||Jane||8|
|month 4 purchase count||Jane||3|
|month 5 purchase count||Jane||6|
|month 6 purchase count||Jane||9|
|month 1 purchase count||Joe||9|
|month 2 purchase count||Joe||8|
|month 3 purchase count||Joe||5|
|month 4 purchase count||Joe||8|
|month 5 purchase count||Joe||0|
|month 6 purchase count||Joe||5|
|month 1 purchase count||Robert||7|
|month 2 purchase count||Robert||7|
|month 3 purchase count||Robert||9|
|month 4 purchase count||Robert||4|
|month 5 purchase count||Robert||9|
|month 6 purchase count||Robert||7|
Ideally, my sheet would look like so:
But I am having difficulty getting Tableau to see each column as an individual month because they are their own measures.
So my question is, how do I combine these into a single working pill so that it can be used in the chart?
- I had some success in creating a caluclated field that would chop off the "Month" and "Purchase Count" to get the month number into a discrete field in which I could plot that way, but combining the measure, I have no clue where to start.
I have the a sample data set attached. I apologize if this question has come up before, but searching the forum has not been fruitful. So linking me in the right direction would also be greatly appreciated.
Thanks in advance for your help!
Combine Measures Test.twbx 9.5 KB