[Tableau] 10. Second date

 

 

 

• Second purchase : { FIXED [Customer ID] : MIN(IIF([[Order Date]] = [First Customer]]], null, [Order Date]))}
• ISNULL: ISNULL([second customer])

 

 

 

• 51 : { EXCLUDE [ISNULL] : COUNTD([Customer Name]) }

 

 

라인&원 이중 축 표시

 

• mark : IIF([ISNULL],'★','')