Creating a Distinct Column Name and Showing Last Completed Order

SLam · July 2020

Scenario: There are thousands of customers that are placing orders on a daily basis, which include repeat customers.

I am trying to build a card that will:

1) Show the customer's name once on my card

2) Show the last time they placed an order.

Is there a way to make the 'CustomerName' column a unique value without creating beast mode? If not, then I could not find any distinct function other than 'Count Distinct' and 'Sum Distinct' which does not give me the customer's name.

Thank you for the help!

jaeW_at_Onyx · July 2020

works as anticipated. with just Min and Max(date)

if this isn't the result you're getting, make sure you don't have anything in the ORDER / SORT clause that would be changing the cardinality expressed.

jaeW_at_Onyx · July 2020

I think you could just put Name on the axis and create a MAX(Date) in a Beast mode.

Unknown · July 2020

Hi Jae,

Is there a way I can remove duplicates from my name column? When I added a beast mode column with max(date), it essentially is the same as an existing CompletedDate column. I think it's because there are duplicate customer names with multiple orders.

jaeW_at_Onyx · July 2020

Upload a Sample dataset that spans these duplicates you're returning to. It's 1AM over here ? but I'll see if I can't get you something for tomorrow.

you can email me directly at jae@onyxreporting.com or DM me in the Global Slack Channel

jaeW_at_Onyx · July 2020

works as anticipated. with just Min and Max(date)

if this isn't the result you're getting, make sure you don't have anything in the ORDER / SORT clause that would be changing the cardinality expressed.

Unknown · July 2020

Thanks Jae!

Creating a Distinct Column Name and Showing Last Completed Order

Best Answer

Answers

Categories