9 Replies Latest reply on Mar 19, 2014 2:26 AM by Ratan Roy

    Need Help

    Ratan Roy
        • 1. Re: Need Help
          Noah Salvaterra

          Several ways to do something like this. I included 2 examples in the attached workbook.

           

          The first method is using a dashboard action. I created a simple worksheet with labeled regions to use as my buttons and selected "use as filter" in the worksheet drop-down on a dashboard that contains both by button worksheet and the one I'd like to filter. Now clicking on a region will filter the top 10 view. Doing it in this way, you're not limited to buttons, you can create another functional worksheet for your dashboard such as a map or a bar chart showing total sales by region.

           

          UseAsFilter.png

           

          The second is a quick filter. Place region on the filter shelf, right click and select "show quick filter" the quick filter has a drop-down to setup how it is displayed.

          • 2. Re: Need Help
            Ratan Roy

            Hi Noah,

             

            Thank you for this. I think it will help.

             

            Could  u please attached the workbook for my reference?

             

            will wait for that.

             

            Regards,

            Ratan

            • 3. Re: Need Help
              Noah Salvaterra

              I thought I had...

              • 4. Re: Need Help
                Ratan Roy

                Hi Noah,

                 

                Thanks a lot. This is exactly what i wanted.

                 

                 

                 

                Regards,

                Ratan

                • 5. Re: Need Help
                  Noah Salvaterra

                  Glad I could help.

                  N

                  • 6. Re: Need Help
                    Ratan Roy

                    Hi Noah,

                     

                    Need your help.

                     

                    Please find attached the example  file. i need to make the top 10 Zip code

                    to be colored with different colour  rest Zip code would be similar.

                     

                    Please help me on this.

                     

                     

                    On Sat, Mar 15, 2014 at 11:50 PM, Noah Salvaterra <

                    • 7. Re: Re: Need Help
                      Noah Salvaterra

                      Hi Roy,

                       

                      I just created a calculated field:

                      iif([Order]<=10,1,0)

                      And used it on color. For some reason this affected size as well, not sure why off the top of my head but it has been a long day so I just put something on the size shelf and it took care of the problem.

                       

                      Note, because you're using dense rank, it is possible that you'll have many more than 10 in the top 10 as a result of ties. You may prefer one of the other rank functions if that isn't what you want there.

                       

                      I just read your post again and realized something might have gotten lost in translation. If you wanted 1, 2, 3, ..., 10 to each be a different color and the rest to be the same you could use a similar approach but change the calculation to:

                      iif([Order]<=10,[Order],0)

                       

                      Does that do it?

                       

                      Curious, do you have difficulty getting questions answered quickly? I noticed your post in the community feed by chance (which shows everything), but it was tagged as "India" rather than "Forum". I've seen a few geo-specific groups like this, but I'm not sure what that is about. In the regular forum area people have been getting to questions pretty quickly, so you might have more luck. I don't mind helping, but there are many people faster than me.

                       

                      Cheers,

                       

                      N.

                      • 8. Re: Need Help
                        Ratan Roy

                        Hi Noah,

                         

                        Thank you for your help.

                         

                        I have tried to implement the same in my workbook, but somehow i am not able to do that.

                         

                        Can u please check this. I have also attached a file in your mail. kindly check it.

                         

                        Actually i am new to this forum. From now, i will directly post my question on forum.

                         

                        Regards,

                        Ratan

                        • 9. Re: Need Help
                          Ratan Roy

                          Hi Noah,

                           

                          Here i have uploaded the file.

                           

                          http://community.tableau.com/docs/DOC-5446

                           

                          Regards,

                          Ratan