▲ 2 r/tableau
Help Combining Multiple Date Fields from Multiple Data sources Into One Field for a Text Table
Hey everyone, I for the life of my can't figure out how to accomplish this. I've reviewed scaffolding, pivots, etc but nothing seems to work. Here is the data structure:
Table 1: Customer ID and Customer Create Date (All records in this table)
Table 2: Customer ID and Customer Order Date (Some of the records in table 1 are in this table)
Table 3: Customer ID and Received Date (Some of the records in table 2 are in this table)
I am hoping to show a simple text table that has the number of customers created, number of orders placed, and number of orders received in the same view.
What is the best way to accomplish this?
u/WMDPandemic — 6 days ago