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

Follow this topic

abdalla

Last answered:

18 Nov 2021

Posted on:

15 Nov 2021

Wrong values for tier calculated field

in Fashion Analytics with Tableau / Creating a Customer KPIs Table in Tableau

2 answers ( 0 marked as helpful)

Elitsa Kaloyanova

Posted on:

17 Nov 2021

abdalla

Posted on:

18 Nov 2021

Wrong values for tier calculated field

Submit an answer

related questions