Tableau Interview Scenarios

Hello Everyone,
In this video we will try to solve #tableauinterviewquestions , #Interviewscenarios of #deloitte , #userready, #important

#tableauinterviewplaylist,
#ai
#besthacks,
#bestinterviewtips ,
#interviewpreparation,
#bestchannel,
#interviewtips,
#interviewpreparation ,
#projects
#percentoftotal
#secondmaxsal,
#secondmaxorder,
#dont_forget_to_like_and_subscribe
#tableau
#powerbi,
#powerbiinterviewquestions,
#powerbiinterviews,
#tableauinterviewquestions
#tableauscenarios
#tableauinterviewexperience.
#tableauinterview,
#Tableaudeveloper,
#tcsinterview,
#interviewquestions,
#viralinterview,
#sqlinterview,
#tableauinterviewquestions ,
#assignment_answer_2021
#projects
#Tableau
#DataVisualization
#DataAnalysis
#BusinessIntelligence
#TableauInterviews
#TableauTips
#DataAnalytics
#DataViz
#TableauExperts
#DataInterviews
#TableauTutorial

#BIInterviews
#TableauDashboard

#TableauDeveloper
#DataDevelopment
#DataProgramming
#TableauTutorial
#TableauTraining

#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
interview questions and answers
data analyst
data analyst interview
tableau interview experience
tableau interview questions in telugu
tableau scenario based interview questions
tableau interview questions in english
how to handle fake experience
tableau interview experience questions
tableau lod
sql interview questions and answers

[Shilpa-qi]

Hey rahul thankyou so much for posting such type of questions..a part from LOD we can also give first n last sale by using index() like if INDEX()=1 THEN min([Order Date]) END and last sales date can be identified by last()..ryt?

[LavanyaRajalakshmi-ec]

hello, it was very helpful, thank u... also i want know calculation formula for month wise 1st & last day sale on every year

[SolaRabi]

[Order Date]={FIXED YEAR([Order Date]): MIN([Order Date])}

or
[Order Date]={FIXED YEAR([Order Date]): MAX([Order Date])}

[veer]

Thanks for such informative in function

[ESAEKHUMAARR]

{ FIXED [Order Date (Years)] : MIN([Order Date]) } = [Order Date] OR
{ FIXED [Order Date (Years)] : MAX([Order Date]) } = [Order Date]

[kinchalsharma]

{ FIXED YEAR([Order Date]) : MIN([Order Date]) } = [Order Date] OR
{ FIXED YEAR([Order Date]) : MAX([Order Date]) } = [Order Date]

[Chandu-ru]

[Order Date]={ FIXED YEAR([Order Date]): MIN([Order Date])}

[vigneshwaranm]

Each year First Sales:
SUM(
IF [Order Date] =
{ FIXED (YEAR([Order Date])): MIN([Order Date])}
THEN [Sales]
END)

Each year Last Sales :
SUM(
IF [Order Date] =
{ FIXED (YEAR([Order Date])): MAX([Order Date])}
THEN [Sales]
END)

[vigneshwaranm]

current week till date / previous week sales
IF
[New Orderdate] < TODAY()
AND
DATEDIFF('week', [New Orderdate], TODAY()) in (0, 1)
THEN [Sales]
END

[Chandu-ru]

[Order Date]={ FIXED YEAR([Order Date]): MAX([Order Date])}