Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

Sample Dataset: gets refreshed everyday.

date      Team name Team ID Result
24/07/2008  lol      458    pass
27/01/2017  pop     1478    fail
28/02/2018  laugh     99    pass
and so on

I want to show dates on x axis and ​Result : Pass or Fail on trend-lines 

So what would be my Y axis?

I want to show the pass or fail- team ID wise on trend lines!

For example, 

If its December month then team ID which have passed /failed for 31st of December 2017 should show up. similarly for Jan month (team ID ) which have passed or failed should show of 31st jan 2018. AND for Feb month it should show pass / fail for current date --- {Team count pass or fail for particular current day}

Can someone please help with calculated filed calculations?

1 Answer

0 votes
by (47.2k points)
edited by

Try This:

if Date= today() then 1

elseif dateadd('day',-

day(DATEADD('month',1,Date)),DATEADD('month',1,Date))=Date then 1

else 0

then set filter to 1

Get indepth knowledge about this field through Tableau Certification Course by Intellipaat.

Related questions

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...