Asutosh Jha

I am looking to change the bin size dynamically. How I can do that

This can be done with the help of the parameter. Let’s create a parameter with some default size Now use this parameter to the BIN. Use this where you specify the bin size

Tableau

Answered Nov 27, 2019 · 1.7K Views Read answer →

I am unable to select the top 6 dates using parameters. It always shows less than 6. What can be the

That’s maybe due to the incorrect calculation. Check the calculations you have done and also your filter where whether you have selected top/bottom.

Tableau

Answered Nov 27, 2019 · 1.5K Views Read answer →

Should I use line chart with bin

although you can do that bar chart or histogram is more preferred

Tableau

Answered Nov 25, 2019 · 1.5K Views Read answer →

Why I am not getting unique ranks for all numbers

There are multiple functions for RANK and all work in different ways. If you want to get the unique rank for all irrespective of the same value, use rank_unique() unction instead of rank function.

Tableau

Answered Nov 24, 2019 · 1.4K Views Read answer →

Can I use the same parameter to show some top and bottom records?

Yes, can be done. For that, you can create two parameters one for showing top and another for bottom records. BINS

Tableau

Answered Nov 22, 2019 · 1.4K Views Read answer →

I want the user to select only a few options like top 1, top 5, top 10. Can I limit those

Yes, can be done by changing the properties of the parameter. While creating or editing the parameters, select list option and provide what you need like below-

Tableau

Answered Nov 21, 2019 · 1.5K Views Read answer →

I have 2 worksheets those were created from 2 different data sources that I would like to place on 1 dashboard. Each worksheet has 3 sets of parameter controls: "Provider", "Start date", "End Date".…

Parameter works for a particular worksheet. If you have two different data sources in a workbook and based upon the different data sources you have created different worksheets then you might need to combine them in the dashboard. but as you mentioned you are using a calculated field in the filter and so your work…

Tableau

Answered Nov 19, 2019 · 1.4K Views Read answer →

I have the data like below. And I want to get an output like Potato Board..

Potato 1TByte 4.5 NFA Board 256GByte 553 NCA Looking at the output you’re looking for, it seems you just want to have the first word from each row. First find the delimiter you think can solve this and put that in a calculated field. The code will look like below- IF (SPLIT(LEFT([Data],…

Tableau

Answered Nov 19, 2019 · 1.4K Views Read answer →

I created a The pie Chart which has so many legends, is there a way to combine all the top-5 into ot

One way to do this is to create the set! Let’s say we need a pie chart on subcategory and want the top 5 subcategories to be shown in one. To do that, first, find the top 5 subcategories based on the sales- Then we need to create a set for these top subcategories-

Tableau

Answered Nov 19, 2019 · 1.6K Views Read answer →

When I added a dimension as a filter, it shows a filter with pillar icon with dimension. Why it is showing like that?

If you are looking for the reason for the below-Then it is information about the filter. It says this filter has been applied to other worksheets also. Once you hover the mouse on this, you will get the details like where all it is applied.

Tableau

Answered Nov 18, 2019 · 1.6K Views Read answer →

I am having a report where first I have 2 dimensions and then one measure.

I want to sort the report based on the sum of the measure corresponding to the 1st dimension. But when I do it sort based on 2nd dimension Let’s say we have the report like below- And you want to sort these on the basis of category and not segment then simply click on category icon and select sort. There select field…

Tableau

Answered Nov 18, 2019 · 1.4K Views Read answer →

I have a report where I am showing the trend for last 30 days.

Is there a way I can make this automated where system can automatically keep on taking last 30 days. Yes, this can be done by adding the date filter and selecting a relative date. There in the days tab select last 30 days.

Tableau

Answered Nov 18, 2019 · 1.5K Views Read answer →