I am working with Redshift tables, will this still apply? Please explain.
Not Sure, but try it with Tableau PREP
I have tired, with no success. I have read the white papers and watched the training videos. I am hoping someone has real world experience
I may not have adequately replicated your datasources,
but I made an attempt to generate a flow to perform the two levels of pivots.
Admittedly, my datasource is Excel, so I'm not completely how that translates
Below are screenshots of the flow and the resultant graph in Tableau.
Attached in the Forum Thread are the tflx, twbx, and xlsx.
If they do not adequately reflect yours, please adjust them and repost.
I just saw in your other post that you are connecting to a live datasource,
and so Prep may not be the current solution for you.
Is it possible to join your tables to a helper datasource, which is simply
a single column of all possible dates (can go well into the future)?
Then you could join both of your tables to the lookupDate with
a connection field of just 1.
This will put IssueDate and RedemptionCreated on one date axis
with one common date filter.
There are extra steps required for the 3 measures. Helper calcs are needed
IF [Issue Date]=[Lookupdate]
and so on for each measure.
Then they can be plotted all using the MeasureName/MeasureValue
method. The problem arises that there is a discontinuity in my
mock dataset because measure 3 doesn't have values for certain
early dates. And so the line for Measure 3 has breaks.
I'll look into that.
Please see workbook v10.3 attached in the forum thread.
Also, I've been looking at this method:
but it may be overly complex for the task at hand.