How to Show Top N within each category using Rank in Tableau

Поділитися
Вставка
  • Опубліковано 14 жов 2024

КОМЕНТАРІ • 32

  • @willhunt370
    @willhunt370 10 місяців тому +1

    Thank you so much for posting this lecture, Darpan! You are a wonderful teacher and lecturer.

  • @deepakdhikale9211
    @deepakdhikale9211 5 місяців тому +1

    Thanks Darpan !! Thats really helped me in my current project

  • @shraddhamehta6547
    @shraddhamehta6547 4 місяці тому +1

    This was a great explanation! Thank you!

  • @mohdyusof3855
    @mohdyusof3855 2 роки тому +1

    thanks sir..u solve my problem...keep doing content even it is simple things.. because it hard for new bee

  • @babybru3154
    @babybru3154 2 роки тому +1

    This video helped me in solving my problem! Thank you for creating useful content on tableau. Looking for more videos.

    • @helpful_tipss
      @helpful_tipss  2 роки тому

      Thanks Palak. I am happy that this video was helpful 👍🏻

  • @gayatrimoorthy9002
    @gayatrimoorthy9002 2 місяці тому +1

    This was a great video!

  • @MrWilrichardson
    @MrWilrichardson Рік тому

    Thanks for this, works great and easy video to follow. Now is it possible to add another measure name for color within each row? When I add the additional detail, the top N no longer follows the set number.

  • @zubinmacwan
    @zubinmacwan 4 місяці тому

    This was great, very helpful!

  • @mohammedabrar2871
    @mohammedabrar2871 2 роки тому +1

    An amazing video brother! keep enlightening and helping us.

    • @helpful_tipss
      @helpful_tipss  2 роки тому

      Thank you. I am happy that this video was helpful👍🏻

  • @shaba9100
    @shaba9100 2 роки тому +1

    Another good video bro 👌 it is very useful to me basically where are u from ?

    • @helpful_tipss
      @helpful_tipss  2 роки тому

      Thanks Bro. Keep supporting the channel 🙂

  • @andyburrows7478
    @andyburrows7478 Рік тому +1

    excellent post Darpan, really helpful!!:)

  • @chethupo
    @chethupo 2 роки тому +1

    Good job Darpan

    • @helpful_tipss
      @helpful_tipss  2 роки тому

      Thanks Chethan. Keep supporting the channel 🙂

  • @cutiepie8217
    @cutiepie8217 Рік тому +1

    What if you wanted to rank in reverse. For example the product with the lowest sales to be ranked us 1 and the product with the most sales with the highest rank.

    • @helpful_tipss
      @helpful_tipss  Рік тому

      For that you can create a calculated field: Rank(sum(sales),’asc’)) and use that in column shelf. By default, the order is ‘desc’ that gives rank 1 to the product with highest sales and lowest rank to the product with lowest sales.

    • @helpful_tipss
      @helpful_tipss  Рік тому

      I have uploaded a new video on this scenario. Link: ua-cam.com/video/tRX8uRMk0fQ/v-deo.html

  • @manjunathfattepur9122
    @manjunathfattepur9122 2 роки тому +1

    is it not applicable to state and city? where i am unable to sort the way you have shown

    • @helpful_tipss
      @helpful_tipss  2 роки тому

      Same steps will also work for state and city. If the bars are not getting sorted in desc order then you can try these steps also. Click on the city dropdown -> click on sort -> sort by Nested -> sort order desc -> field name Sales.
      Let me know if you face any difficulty

  • @mayankshrivastava5679
    @mayankshrivastava5679 4 місяці тому

    How to show top 3 as table instead of bar

  • @Techno1497
    @Techno1497 2 роки тому +1

    I have been asked By recruiter
    Find Top 10 Categories, subcategories wise product name

    • @helpful_tipss
      @helpful_tipss  2 роки тому +1

      Yes. This is one of the important Tableau question. Hopefully you would have been able to answer him 🙂

    • @Techno1497
      @Techno1497 2 роки тому

      @@helpful_tipss Nowdyz Interviewer ask to install tableau for case! Could u please share the important case question that will be very helpful

  • @hk2in
    @hk2in 2 роки тому

    Isi ko pie chart banana ho toh kya karu