Mastering Complex Real-Time Tableau Challenges|P-1

Hello Everyone In this video we will solve #tableaudeveloper #challenge
#realtime. As a #developer we are required to write #ytd,#mtd,#qtd, #yoy
#video will help you in #solving that. #calculate
#YTD
IF DATEDIFF('year',[ORDER DATE],TODAY())=0
AND [ORDER DATE] Less than TODAY()
THEN [SALES] END

#PYTD
IF DATEDIFF('year',[ORDER DATE],TODAY())=1
AND [ORDER DATE] Less than DATEADD('year',-1,TODAY())
THEN [SALES] END)

#QTD
IF DATEDIFF('quarter',[ORDER DATE],TODAY())=0
AND [ORDER DATE] Less than TODAY()
THEN [SALES] END

#PQTD
IF DATEDIFF('quarter',[ORDER DATE],TODAY())=1
AND [ORDER DATE] Less than DATEADD('year',-1,TODAY())
THEN [SALES] END)

#MTD
IF DATEDIFF('month',[ORDER DATE],TODAY())=0
AND [ORDER DATE] Less than TODAY()
THEN [SALES] END

#PMTD
IF DATEDIFF('month',[ORDER DATE],TODAY())=1
AND [ORDER DATE] Less than DATEADD('year',-1,TODAY())
THEN [SALES] END)

#challenge,
#interviewquestions , #interviewchallenge
#kpmg,
#viralinterview ,
#capgeminiinterview ,
#tableauinterview,
#Tableaudeveloper,
#interviewquestions,
#tableauscenarios,
#sqlinterview,
#tcsinterview,
#creatingforindia
#DataViz
#TableauTips
#RealTimeAnalytics
#MasteringTableau
#DataAnalysis
#TableauTutorial

Please like share and subscribe.

#xpressurdata
#tableau
#tableaututorial
#tableaudeveloper
tableau interview
tableau training
tableau desktop specialist exam
tableau interview questions & answers
tableau interview experience
tableau interview questions
tableau developer interview questions
tableau interview questions in telugu
tableau interview questions in hind
tableau desktop specialist
tableau certification
tableau desktop specialist exam questions
lod in tableau
tableau server tutorial
tableau server
tableau lod
sql interview questions and answers
xpressurdata
parameters in tableau
filters in tableau
tableau projects