Asutosh Jha

What is complex data type in tableau

As of now, Tableau is having following data types-There is nothing called a complex data type currently with Tableau. But an idea has been submitted where people have requested for some kind of data type which can store structs/arrays. You can check that idea here.

Tableau

Answered Nov 9, 2019 · 1.8K Views Read answer →

How to access saved data sources

Saved data sources can also be accessed from the repository location. Just follow the above steps and follow the Datasource folder instead of the Workbooks folder and you will find all the saved data sources.

Tableau

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

I need to create a calculated field using this logic: # of casesIF status = closed then use the date resolved fieldIF the date resolved is blank then want to use date closed field.

For this, you can write a calculated field with the code like below- IF [STATUS] = 'Closed' THEN [Date Resolved] ELSEIF ISNULL([Date Resolved])=TRUE THEN [DATE_CLOSED]

Tableau

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

As we can't import the calculated field in salesforce to tableau directly. Is there any turnaround for this?

Importing directly might not be possible but you can always replicate the logic in tableau. For example, if you have done some calculations at the Salesforce end, you can do a similar calculation in the tableau calculated field as well. You can further check the article by tableau which share some best strategy on it-…

Tableau

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

I am using a URL parameter in a dashboard action. What I want to do is to open it to a new tab. Is there any option to open a new URL in a new tab?

Yes, this can be achieved with the help of a line chart. Usually, what happens when you drag these Dimensions & Measures into the self, Tableau will automatically select the best chart for your data. All you have to do over here is going to the March self and from the chart type, select the line chart. by default, it…

Tableau

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

I need to create a dynamic pie chart or a set of them. I have my first pie chart with my data, however, I want to be able to click on one of the slices and it either opens a new pie chart that breaks…

This can be achieved with the help of a dashboard. We have an option called dashboard action. Using dashboard action you can achieve this requirement. let's say you have two worksheets with the name sheet1 and sheet2. add both the worksheets into the dashboard. Now go to the dashboard action and click on the add…

Tableau

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

I have created a pie chart that looks fine but when I select one dimension it becomes cluttered. how to correct it

This might be due to the label overlapping. one way to prevent disease don't click on the T-icon showing you at the top. Instead, drag the dimension or measure to the labels shelf in the marks card and also don't check overlap with each other checkbox.

Tableau

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

How to create a dual-axis with 3 lines with 3 different marks types like line, bar, and circle.

You can do this by reshaping your data and drawing the bar chart and circles using the line mark type, but it takes quite a bit of calculation. A much easier alternative could be to use a reference line instead of a circle with the bars.

Tableau

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

I want to have all the value of id but when I am using it, it gives the sum of ids

You’re getting the sum of ids because it is the measure and while using the measure, the default nature is, it will be aggregated on a higher-level. The default aggregation is the sum and if you need anything else, you can change it. Now if you don’t want summation of ids to be shown, then simply convert that to…

Tableau

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

Getting the following error while connecting data. please suggest the solution.

There can be few issues related to this- Check if you have the required access to the data you’re connecting. For example, if you are willing to connect an excel sheet to tableau then make sure you’re having proper right on it. Another reason can be due to space crunch. Make sure your system has enough memory. To…

Tableau

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

How to identify if the column is using continuous data and discrete data

Use that dimension/measure and see what data it is taking. Whether it is continuous or discrete Another option is to right-click on it and see what option you’re getting. If you’re getting an option for converting to discrete means, it is currently the continuous data and vice-versa.

Tableau

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

How I can remove the "All" option from the filters

All option comes by default with any filter. We can remove this by following filter icon → Customize → unchecked show all optionLINE CHART

Tableau

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