Very useful and request to provide a function of how to then calculate the average days after getting difference of all dates created from using "Datediff" function

Excellent Video. Thanks for this!!!

@DataVizCanvas

2 жыл бұрын

Thanks Deepak :-)

Useful video. Thanks for sharing your valuable knowledge.

@DataVizCanvas

Жыл бұрын

Thanks for your feedback and supporting my channel. Cheers!

Please make a video on time calculation, like last hour, last interval, or last 7 interval, or substrate addition, and percentage difference from previous interval or hour and percentage difference from previous day, That would be really helpful

@DataVizCanvas

3 жыл бұрын

Thanks for you feedback Nitin. Will definitely create more on time calculations. Please stay tuned :-)

Super useful, Thanks ,👍

@DataVizCanvas

9 ай бұрын

Thanks a lot for your feedback. Please share our content with others to help even more community members benefit from what we have to offer 🙌.

Sir !! is deserve More subscribe!! I m sharing in separate Group!!

@DataVizCanvas

Жыл бұрын

Thank you so much 🙏 Appreciate it 😊

7:36 We already change a fiscal starts from April(Data source & Order date itself). Then why January belongs to Q1 and April belongs to Q2 .

@DataVizCanvas

2 жыл бұрын

Hi, In this tutorial we have used Jan as a fiscal start date. If you change the fiscal start date at data source level to April then the Q1 will start from April. However you can override that by going to individual date field and right click to go to default properties and select fiscal start to lets say Sep then the Q1 will start from September. Hope that answer your query. Please feel free to reach out if you need more info. Cheers!

Hi , at 16:30 after you put the sum(datepart) in the text , do you not need to change it to dimension to get the month, as it was left as a variable which does not matches the function result that should be the integer for the corresponding month?

@DataVizCanvas

Жыл бұрын

Hi Anil, Thanks for your feedback and great pick up. Yes you are right. Datepart field should have been changed to dimension to give us the correct month. Sum(DatePart) is aggregating all the month (integer ) values which is not correct. And in order to show the name of the month, we should use datename function as shown in the tutorial. Cheers! Gurpreet

how to create a date range based on the start date and end date options?

@DataVizCanvas

2 жыл бұрын

Hi Ashwitha, you can create a parameter with date data type for start date and end date. Once you have that created then you can create a calculated field based on your date field like Date >= start date (Parameter) and Date

Find it hard to see the screen..no clarity..please take care..nice vedio

@DataVizCanvas

2 жыл бұрын

Thanks for your feedback Reshma. Will see what I can do to improve the video quality.

very useful video but the background music is distracting

@DataVizCanvas

4 ай бұрын

Thanks for the feedback. Will see what I can do in future videos

Kindly zoon into the screen ..sometimes it is very hard to see the variable names and all.

@DataVizCanvas

2 жыл бұрын

Thanks for your feedback. I will see what i can do in future videos to overcome this issue. 🙂

What does date function do? How to use it?

@DataVizCanvas

Жыл бұрын

Date function convert the string values into date format.

@sadafnidah8245

Жыл бұрын

@@DataVizCanvas ok so date function only works on string values. I used it on numeric column I was getting error in year. So how to convert a numeric date to date data type in tableau?

@DataVizCanvas

Жыл бұрын

@@sadafnidah8245 If you have an interger value like 20220203 then first thing you need to do is to change the data type by right clicking on the field and got to change "data type" and select "date" All the date function works with strings and date data type. If that still doesnt work then convert it into string and then try date function to convert it into date. Hope that helps 🙂

@sadafnidah8245

Жыл бұрын

I was told to convert numeric date column using calculated fields , so I was getting error on using date function for it in calculated field. Will do the string conversion and then use date function as suggested. Thanks 😊

@DataVizCanvas

Жыл бұрын

@@sadafnidah8245 You are welcome 🙂. Feel free to reach out if you need more info. Cheers!

Content is good. Video quality very bad.

@DataVizCanvas

2 жыл бұрын

Thanks for the feedback. Will see what I can do to improve the quality in future tutorials. 🙏

The quality of video is very poor. Please make next one with high visibility.

@DataVizCanvas

Жыл бұрын

Thanks for your feedback. I will see what I can do to uplift the video quality. Also would appreciate if u could check the quality setting in KZread right bottom and set it to HD, sometimes if internet speed is slow it’s automatically reduce the quality setting to low so you have to adjust manually to higher setting. Hope that helps 🙏

Blur video waste

@DataVizCanvas

2 жыл бұрын

Thanks for your feedback Vijay. Will see what I can do to improve the quality in future videos. Cheers!