I'm having different values for tiers and i wonder is the data been changed or something wrong from my side. noting that i have the exact same code and conditions IF [Consumer LTV] <= { FIXED :PERCENTILE([Consumer LTV], .33) } then "Tier 3" ELSEIF [Consumer LTV] <= { FIXED :PERCENTILE([Consumer LTV], .66) } then "Tier 2" ELSEIF [Consumer LTV] <= { FIXED :PERCENTILE([Consumer LTV], 1) } then "Tier 1" END

Hi abdalla, thanks for reaching out! When loading the two databases in Tableau, you need to join them on the consumer ID column to get the correct results. You might be getting a different result, if the data has been joined on different columns (I think the purchase ID is sometimes taken by default). Let me know if there's still an issue! Best, 365 Eli

Hello Eli, as per the image below the join condition i chose is indeed on consumer id. But the interface is different from the one in the course. please advice. Regards, Abdalla