Very helpful video rayapati.. thank u 🙏🙏

thats really great vedio which gave me clarity of entire Date related functions....thanks a lot sir

This is really good video. Brilliantly explained. Thank you!

@Rayapati

2 жыл бұрын

Thank you Adrian

Absolutely beautiful explanation

way of explanation is too good it's easy capture the concept 👍

@Rayapati

3 жыл бұрын

Thank you Rohit. Actually Tableau is easy if you know where to look for and how to validate

Great video, thanks. Is there a way to dynamically control all these four measures. For example; if a user would like to have a drop down month filter and based on the month selection the four fields gets calculated. Thanks in advance.

@Rayapati

2 жыл бұрын

Yes, it can done using Parameters. Please visit www.rayapatianalytics.com for details regarding Scenario based Tableau Training.

Thanks For valuable information it will help a lot in real time work as we need to work on data for specific period so we can use this video for reference. if it is possible please make a video on previous 15 days and prior 15 days comparison .

@Rayapati

2 жыл бұрын

I think this scenario you should be able to try it by watching this Video. If your stuck in middle while resolving the scenario. You share you image in our website public forums to get suggestion or logic on the solution. Please visit www.rayapatianalytics.com for details regarding Scenario based Tableau Training.

Hi could you please make a videos on row level security and hierarchical level security on tableau...

Really appreciate your teaching. Please keep uploading new video. Very helpful.

@Rayapati

3 жыл бұрын

Thank you Madhukar for the feedback.

@Rayapati

2 жыл бұрын

Please visit www.rayapatianalytics.com for details regarding Scenario based Tableau Training.

Thanks for valuable information. How to calculate last year sale by using Datediff? Can you tell me the formula?

Valuable video, thanks for explaining. Please make video for MTD , MOM, QTD, QOQ, if it's already there please share the link.

@Rayapati

2 жыл бұрын

I left them for users to practice and understand well. If your stuck in middle while resolving the scenario you have asked, You can share you screen image in our website public forums to get suggestion or logic on the solution. Please visit www.rayapatianalytics.com for details regarding Scenario based Tableau Training.

very good video thank you

Rayapati I'm looking for MoM and QOQ spilit with Parameter can you please share something like that

Thanks for this video !

@Rayapati

2 жыл бұрын

Welcome

You are good tutor man...❤️ U

@Rayapati

2 жыл бұрын

Thank you Koti for the feedback

how do we calculate the YOY for Financial Year starting as April and not January

But i want financial year start from april instead of jan for ytd, how to achieve that... Thanks

Nice Explanation

@Rayapati

3 жыл бұрын

Thank you Sridhar

super bayyaaa..well explained very nicely. r u frm guntur sir?

@Rayapati

3 жыл бұрын

Thank you.

When our dataset has data only upto 2020 then how did you get the data for 2021 like sales.Can you please elobrate it

@manjushakata8751

3 жыл бұрын

And what if we want data from start of the year to a particular date like March 2021

@manishmishra6245

3 жыл бұрын

yes exactly..how YTD is there for 2021 till feb while we have no sales data for 2021..please explain why we have taken Dateadd('year', 1,orderdate),,means order date year is 2020 but showing calculation of sales of 2021 against that..

@Rayapati

3 жыл бұрын

Dateadd('year's, 1,orderdate) will help add one year to all the dates in order date. All the dates with year as 2017 will now have 2018 as the year. Same way all the dates with 2020 as year will now have 2021 as yeat

How can you do this if my fiscal year starts in February? Facing a problem here

@Rayapati

2 жыл бұрын

Try using nested if function required month to get fiscal year. This is detailed in our Training sessions only as it is very lengthy to explain here. Please visit www.rayapatianalytics.com for details regarding Scenario based Tableau Training.

@farrukhkidwai

2 жыл бұрын

@@Rayapati Thanks

If we have data from 2012 - 2015 then, how would you execute it?

@Rayapati

3 жыл бұрын

Use Dateadd('year', 6,orderdate) which will move year to 2021

@manishmishra6245

3 жыл бұрын

@@Rayapati so basically it is ideal approach to check the latest year in data source and then add that many years to make current year; By taking user input for year would be much flexible..right?

@balucivil6122

3 жыл бұрын

You can use a parameter .. instead of static value ...

this video support to me

How do we calculate Recurring growth and also how can we find Recurring% can you please explain

@Rayapati

Жыл бұрын

Attend Monday's doubt session. We can discuss there

@samdanimohd9700

Жыл бұрын

Sure thank you

Hi Rayapati , could you plz let me know how to contact you ? I’m looking for Tableau hands on exp projects and other general questions