Asutosh Jha

How to union 3 worksheets to make 1

You won’t be able to make a union of the worksheet. It is advisable to the union on the data itself and then creates the required reports on it.Still, if your requirements are not fulfilled then what you can do is create 3 separate worksheets and then arrange those in the dashboard. While arranging, keep the header…

Tableau

Answered Aug 12, 2019 · 1.5K Views Read answer →

How to resolve the "not enough space" issue with tableau server

This error arises when your system is not meeting the minimum hardware requirements asked by the tableau desktop or tableau server. Below are the requirements for Tableau desktop and server to install and ensure you’re meeting the minimum requirements- Tableau server: 8 core, 2.0 GHz or higher processor 64-bit…

Tableau

Answered Jul 12, 2019 · 2.1K Views Read answer →

If I enter 4 in my parameter value the filtered values coming as 3. that is one less in each case. What can be the possible reason here

There might be a problem with some other filters. For example, let’s say you have a filter using which you are controlling the top 4 and at the same time you are also using another filter which is finding the subset of the data. In such a case, the previous filter result can be changed a bit. Please check all your…

Tableau

Answered Jul 11, 2019 · 1.6K Views Read answer →

How to create a pie chart to display the return in % per segment. But when I do, size is the same for all. how to correct

This is a common problem with the pie chart. Usually, what we do is show the percentage contribution by each category. and to differentiate between the different areas of the pie chart we put the category into the color shelf. but as we know, the pie chart also depends on the sizes and so, the size remains the same…

Tableau

Answered Jul 11, 2019 · 1.6K Views Read answer →

In the line chart, how to scatter it on the basis of the color?

A line chart can also be scattered in the same way you have been scattering a bar chart. Let's say you have a line chart for yearly sales data. if you want a dense color to do the areas where the sales are high and lighter color where the sales are low. To achieve this all you have to do is drag sales measure and put…

Tableau

Answered Jul 11, 2019 · 1.6K Views Read answer →

I have a global context filter but I don't want it on one worksheet but still want to use it as a global filter.

If you have applied the global filter then it will be throughout the workbook using that dataset and we can’t exclude some part of it. If you don’t want some of the worksheets to be included in that, you may use context filter and proceed. Remember context filter will be applied to that worksheet itself. You may…

Tableau

Answered Jul 11, 2019 · 1.6K Views Read answer →

After the upgrading of the tableau desktop, I am getting an issue while running the query.

There can be various reasons for this. One of the most common reasons can be due to the fact that when you upgrade the tableau desktop, a new version will be installed on your system. But when the new version will be installed on your system, older versions won’t get automatically uninstalled. And so, your system will…

Tableau

Answered Jul 11, 2019 · 1.6K Views Read answer →

When to use tableau desktop and server?

Both are different tools and used for different purposes. Tableau desktop is used for the report development while the tableau server is used for hosting those reports and sharing with others. Although you can edit the reports on the tableau server as well, the major development will be done on the desktop product.…

Tableau

Answered Jul 11, 2019 · 1.6K Views Read answer →

Where to develop the report to publish on the tableau public

You can develop the report on tableau desktop and then connect the tableau desktop to your tableau public account to publish it. Just make sure you are not having any sensitive data when you’re publishing your report to tableau public. Although you can edit the report on the tableau server as well.

Tableau

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

I would like to know how can I calculate the SUM of the field that contains value where the unit is tones and the SUM of the value where the unit is Ha.

You can create a couple of calculated fields to normalize the data. Sample Let's create a table or view and add a new column like belowNow let's create a calculated field for the first unit in tonesSecond calculated field

Tableau

Answered Jan 9, 2019 · 1.6K Views Read answer →