Asutosh Jha

How to create a step chart?

Step chart is nothing but the line chart with some formatting done. Let’s say you have a yearly sales chart. By default, it will be a normal line chart. Now if you want to convert this line chart to a step chart, you need to click on the path under marks and select the kind of chart you are looking for. This will…

Tableau

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

Is it possible to make a line chart specific to milliseconds?

So far I only see the smallest date format is seconds. Directly we don’t have but we have an alternative. You can do this by selecting date → Format → Custom → and then write yyyy-MM-dd HH:mm:ss.000

Tableau

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

Is there an easy way to create bins for a number of different dimensions at one time? I have 60 items and I want to create bins for each one.

If you want to create separate Bin on all those different dimensions then you will have to create those separately. but while creating the bin, if you want to combine all those dimensions then you can Press control and select all and then create the bin on all those dimensions. how to use salesforce calculation in…

Tableau

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

I have created the bin but still getting an older bar chart

There may be a reason that you might not have used the created bin. Usually, we keep the BIN name the same and so a confusion might occur. Just double-check that.

Tableau

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

I have 4 elements to hierarchy but I want to show the last element of it at the default view. How I

Just drag the last element to the first and that element will be in the default view

Tableau

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

I have a dual-axis with sales and profit. I have synchronized but now on one axis sales are showing which is confusion. how to rename it to values?

I hope you will be having the graph like below-Now if you made one of the axes hidden then definitely the other will be shown only sales or profit depending on what you have made hidden. To avoid this issue, you can rename the axis and make the name as sales/profit like below-

Tableau

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

Can I use both measures and dimensions in the hierarchy?

Measure can’t be added to the hierarchy. But if you think you can convert that measure to dimension without any issue then that can be added. This is just a turnaround, if not impacted. PARAMETER

Tableau

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

When we edit the Calculated field so we go Like Analysis --> Edit Calculated Field and there appears "Number of Records" by default I tried to explore it but unable to understand. Why the default…

The number of records is the default field in tableau. When you connect a data set to tableau this is the default field that gets generated along with few other fields. And so, when you are using this number of records in your view it will simply calculate the total number of records in that particular cell. if you…

Tableau

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

How manual sort works?

A manual sort is used when we want to rearrange the items manually. There are two options to do so- 1. Directly in the view, drag or drop 2. Click on the dimension and select manual and then move the values

Tableau

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

I am having a filter on one dimension which has 10 options.

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 Nov 13, 2019 · 1.5K Views Read answer →

How to find the total days from sales date to ship date

You can achieve this with the help of the calculated field. We have datediff() function which can be used to calculate the difference. Syntax: DATEDIFF(date_part, date1, date2, [start_of_week]) And so, you can write like: DATEDIFF(‘day’, order_date, ship_date)

Tableau

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

How to find total hours took from the ordered date to shipped date

Just use the datepart as an hour in the datediff() function and you will get difference in an hour. DATEDIFF(hour, order_date, ship_date)

Tableau

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