I'm going to need a workbook to understand your requirements better.
Consider this: Anonymize your Tableau Package Data for Sharing
I can't figure out what you mean by frequency.
We can do a table calc that will concatenate all the products your filter will generate, but that value will exist only for the duration that the filter is in effect. If someone selects your two example dates and you generate "AC", when they change the dates in the filter you will have no visibility to the "AC" that was previously generated. You will only see the new generated value based on the filter selection.
Obviously, my request wasn't very clear. You will find attached (in the first post, can't add in this message) an example of what's my final goal.
So, I've some ID customers, who buy some products at diffent dates : according to their purchases, the target is different. For example, the customer 1 in my example was step 1 on 20/02/2018 and move to Step 2 on 07/03/2018. My goal is to have the chart designed in the file.
I've tried different ideas find on the forum but the result is not the good one..
For information, I want to select 2 dates for visualize the evolution. I did a filter and I want to have the step of the earliest date at the top of the chart. Then, it would be perfect if the chart only include customer who did a purchase on the first selected date.
Then, I would add to the dashboard the other chart.
Any idea ?
In the attached (V 10.5) I took your data and made a basic sheet of it. (Sheet 1).
In sheet 2 I created a FIXED LOD calc that tells you the first date of any step for any [ID]. In Sheet 3 I just changed the order of the pills on the ROWS shelf.
I'm still not clear on what you are looking to do, but I think at least one step will need to find this first-date for each step for each ID.
Melanie.twbx 85.5 KB
Many thanks Joe !
Unfortunately, it's not what I need.
I will explain with an other representation : here I have ID, and steps are represented by colors. For example, 007 is still at the step 1, 279 did his first purchase on 30/03/2018, and 380 move from one step to an other step.
My wish is to know how many people are in each situation (so, 5 steps, 25 possibilities).
Hope it's clear !
I need a workbook from you.
You can see what I did with a simple excel file. Do the same for me and we will work with that. Otherwise I'm just guessing, and we've already seen that I'm not guessing well.