Asutosh Jha

How to clean all the dimensions and measures used from the worksheet

There can be various measures, dimensions, and other calculated fields on your worksheet. Sometimes, this becomes very crowded and starts giving issues to achieve the desired result. And so, if you want to clean your worksheet, there can be two options Remove each component one by one Clean the entire worksheet If you…

Tableau

Answered Jan 13, 2020 · 1.6K Views Read answer →

I have formatted a worksheet and want the same to other sheets also. How to do that?

There is an option in the worksheet through which you can achieve this. Let’s say you have created a worksheet-1 and have formatted it. And now, you have let’s say 3 more sheets. And if you want to copy the formatting of worksheet-1 to another sheet then, you just need to copy the format of worksheet-1 and then paste…

Tableau

Answered Jan 13, 2020 · 1.7K Views Read answer →

How to add more than 2 numerical values in rows in dual-axis?

You can achieve this just by following the below steps- Keep two measures as row and made it dual-axis Keep 3rd and 4th as details and add them as a reference line Edited reference label as a symbol (one as round and other as a triangle) Scope for the reference set as "per cell" This way you will be able to achieve…

Tableau

Answered Jan 7, 2020 · 1.6K Views Read answer →

I want to open a separate worksheet/dashboard when I click on one bar chart. how to do that

This can be achieved using a dashboard action. We have a dashboard action that helps you navigate to a specific worksheet upon clicking on one chart on the dashboard. Let’s say you have a dashboard with a chart- category vs sales. Now go to the dashboard and select action. Here follow add action → go to sheet. Here…

Tableau

Answered Jan 7, 2020 · 2.0K Views Read answer →

I want to create one bar chart and when I Drill down the bar chart then it should display a Line chart or some other chart.

To achieve this, you can create 2 worksheets- 1 bar chart on which you want to click Line chart which you want to see upon clicking on the 1st bar chart Now you can create a dashboard with both the chart and use the first bar chart as a filter. After that, once you click on the bar chart, the corresponding data in the…

Tableau

Answered Jan 5, 2020 · 1.6K Views Read answer →

I have a 3 line chart for the same dimension and 3 different measures. How to combine all those in one.

This can be achieved with a combination of measures and dual-axis. Let’s say the 3 measures are- Debt Value and Score Now what you have to do is just put debt and value to the measured field and the same measure field to the row shelf also and place score field to next of measure field in the row shelf. Now make the…

Tableau

Answered Dec 21, 2019 · 1.8K Views Read answer →

I have a dataset with time in a small interval. can we create a line chart for millisecond interval

There are a couple of options using which you can achieve this- Using the exact date format you can click on the date and select format. and then go to custom option and there write- yyyy-MM-dd HH:mm:ss.000 These are a couple of options using which you can achieve the fractions of your time period. For

Tableau

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

can we map in the dual-axis? If yes, how to do that?

Yes, we can do that but that will be something called a dual-layered map chart. To create this, just follow the below steps- Drag the longitude and latitude in the column and row shelf respectively Select the map from the marks card. By default, it will be automatic Now while pressing the Ctrl button, drag the…

Tableau

Answered Dec 19, 2019 · 1.7K Views Read answer →

I am creating bins and I want to show customer count for each bin. In some of the bins, no customers in those bins will show zero but I am not getting those bins at all.

This can be a problem because in some of the bins the number of customers is zero. if you still want to show those beans then you need to use the option so missing values. To allow Showing missing values, you can click on the dimension and check that option.

Tableau

Answered Dec 17, 2019 · 1.7K Views Read answer →

I have created a Bins for profit. my requirement is wanting group all the negative profit bins(less than 0) and to be shown in a single bar(count) on the left axis of 0$ and positive bins should be…

You can achieve this solution with the help of a calculated field. Quickly, create a calculated field and use the below code in it- IF [Profit]And now you this calculated field on the x-axis. This will group all the negatively created BINS. you may customize this calculated field as per your requirement as well.

Tableau

Answered Dec 15, 2019 · 1.5K Views Read answer →

I am using only 3 options in the report and want only those 3 options to be shown to the user in the

I am using only 3 options in the report and want only those 3 options to be shown to the user in the filter. But when I show filter all 10 values are showing This is a common issue. To solve this, we can create a set with those 3 values of that dimension and then can use that set as a filter that can solve your…

Tableau

Answered Dec 15, 2019 · 1.4K Views Read answer →

I have some data with which I want to build a histogram. I would like to build bins that are "uneven"

A report with Bin for histogram usually has the intervals of the same size. If you want the interval to be different then you can create a calculated field and use that calculated field as a dimension to create your report. For example, you may keep 0-10 as one category, 10-15 as another category, and so on. Later,…

Tableau

Answered Dec 12, 2019 · 1.6K Views Read answer →