Year to Date (YTD), (LYTD), Year Over Year Growth (YOY) Calculations in Tableau
HTML-код
- Опубликовано: 8 сен 2024
- Year to Date (YTD), (LYTD), Year Over Year Growth (YOY) Calculations are the most common yet most confusing Calculations in Tableau.
Scenario-Based Tableau Training - New Batch - 3rd Sunday of every Month
Call +91 9121314333 for Details
For the Syllabus of the Course, visit the below link
docs.google.co...
For the Videos and Scenarios of Week 1 of previous Batches
drive.google.c...
#tableau #tableautraining #tableaurealtime #realtimetableautraining #tableauscenarios #tableausoftware
#tableaudesktop #tableaudeveloper #rayapatitableau #datavisualization #realtimeanalytics #datafam
Want to get full clarity on it? Whatch the Video
Need Job Support? Whatsapp - +91 9121314333
Have a Doubt and want to ask me? Join the below Telegram Channel
Telegram Channel - t.me/joinchat/...
Need Workbook for Hands-on Practise? Follow my Tableau Public page
Workbook - public.tableau...
Social Media:
Linked IN - / rajeswar-rayapati
Facebook - / rrayapati
Instagram - / rayapati_raj
Twitter - / rajrayapati
#yeartodatetableau #yeartodatecalculations #yearoveryeargrowth
#YTDcalcualtions #YTDtableau #YOYTableau
#rayapatitableau #rayapatianalytics #tableautrainingforfreshers #tableautrainingforbeginners
#tableaurealtimescenarios #tableauinterviewquestions #tableaujobsupport #jobsupporttableau #interviewquestionstableau
#realtimescenariostableau #Levelofdetailexpressions #lodstableau #tableautraining #rayapatiyoutubechannel
This is really good video. Brilliantly explained. Thank you!
Thank you Adrian
thats really great vedio which gave me clarity of entire Date related functions....thanks a lot sir
way of explanation is too good it's easy capture the concept 👍
Thank you Rohit. Actually Tableau is easy if you know where to look for and how to validate
Absolutely beautiful explanation
Very helpful video rayapati.. thank u 🙏🙏
Really appreciate your teaching. Please keep uploading new video. Very helpful.
Thank you Madhukar for the feedback.
Please visit www.rayapatianalytics.com for details regarding Scenario based Tableau Training.
Valuable video, thanks for explaining. Please make video for MTD , MOM, QTD, QOQ, if it's already there please share the link.
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.
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 .
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.
You are good tutor man...❤️ U
Thank you Koti for the feedback
very good video thank you
Thanks for this video !
Welcome
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.
Yes, it can done using Parameters. 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...
Thanks for valuable information.
How to calculate last year sale by using Datediff? Can you tell me the formula?
Nice Explanation
Thank you Sridhar
But i want financial year start from april instead of jan for ytd, how to achieve that... Thanks
Rayapati I'm looking for MoM and QOQ spilit with Parameter can you please share something like that
how do we calculate the YOY for Financial Year starting as April and not January
super bayyaaa..well explained very nicely. r u frm guntur sir?
Thank you.
can we have total in Feb ?
this video support to me
How do we calculate Recurring growth and also how can we find Recurring%
can you please explain
Attend Monday's doubt session. We can discuss there
Sure thank you
How can you do this if my fiscal year starts in February? Facing a problem here
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.
@@Rayapati Thanks
When our dataset has data only upto 2020 then how did you get the data for 2021 like sales.Can you please elobrate it
And what if we want data from start of the year to a particular date like March 2021
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..
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
If we have data from 2012 - 2015 then, how would you execute it?
Use Dateadd('year', 6,orderdate) which will move year to 2021
@@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?
You can use a parameter .. instead of static value ...
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