Skip to main content
Topics#Tableau Desktop & Web AuthoringShaunak Ponkshe's Question
Shaunak Ponkshe asked in #Tableau Desktop & Web Authoring
Feb 20, 2020, 11:22 AM

Customer

Hi All,

 

Can we find who is the first customer who purchased the first product in superstore data using LOD?

4 answers
  1. Bhadresh Maniya
    Feb 20, 2020, 12:00 PM

    Hi Shaunak,

     

    You need to create one calculated fields which is as below

     

    { FIXED [Customer Name],[Product Name]: min([Order Date]) }

     

    Hi Shaunak, You need to create one calculated fields which is as below { FIXED [Customer Name],[Product Name]: min([Order Date]) } Drag and Drop below screenshot dimensions into Rows section.

     

    Drag and Drop below screenshot dimensions into Rows section.

    pastedImage_3.png

     

    Write Down Index() into Rows section and Right Click -> select 'Discrete'

    pastedImage_4.png

     

    Drag and drop above index() into Filters section and select 1 value checkbox.

     

    pastedImage_5.png

    pastedImage_6.png

     

    Your expected output as below.

     

    pastedImage_7.png

     

    Let me know if you have any issue.

     

    Please find attached workbook for your reference.

Write an answer...
0/9000