Hello,
I have a request I am hoping I could get some help with.
I need to show a stacked bar/regular bar chart of the total number of customers and the number of customers newly ordered by week. That means the number of customers newly showing up by week who have not been there in the previous weeks.
I was able to get the total number of customers by week but cannot determine the calculation for the new customers by week.
Please help.
Attached workbook :) I use Tableau 2020.2.2.
Thank you,
B
Hi Bella,
To calculate new customers, give this formula a try:
{ FIXED [Order Date]: COUNTD(IF {FIXED [Customer Name]: MIN([Order Date])} = [Order Date] then [Customer Name] END)}
Then drag this onto rows, and use a dual axis. be sure to synchronize the axes.
Not a lot of new customers for 2019, but there's a bunch in 2016/2017, which is probably a better example.
Hope this helps!
-Graham
